Any RegEX Expression to get the content of "Split List" in regexstorm tester?

[hsendel]

Dears,

Any RegEX Expression to get the content “Split List” in .NET Regex Tester - Regex Storm ?

Thanks In advance

[Yoichi]

Hi,

Do you need expression which outputs like the Split List? The following expression returns string array.

System.Text.RegularExpressions.Regex.Split(yourString,"PATTERN")

Regards,

[hsendel]

Thanks @Yoichi , Please check this link and go to “Split List” to see what I need as output :
.NET Regex Tester - Regex Storm.

[Yoichi]

Hi,

Do you need like the following worksheet or datatable?

If so, the following will work.

arrStr = System.Text.RegularExpressions.Regex.Split(strData,"[^\w\d\-\ ]+")

dt = arrStr.Select(Function(s,i) dt.LoadDataRow({i,s},False)).CopyToDataTable()

Sample20211117-a.zip (3.0 KB)

Regards,

[hsendel]

Thanks @Yoichi , it’s working fine , Just need to know how to remove hyphen “-” from beginning of sentence ( highlighted here in Yellow)

Note : Dash ( big hyphen) “—” is already removed by RegEX expression shared above.

[Yoichi]

Hi,

Can you try the following expression?

strData = System.Text.RegularExpressions.Regex.Replace(strData,"(?<=^|\.\s*)-+","")

Regards,

[hsendel]

@Yoichi

strData = System.Text.RegularExpressions.Regex.Replace(strData,"(?<=^|\.\s*)-+","")

But this will remove even hypen in " Unix-Based" word, no? … I want it to be removed only at the beginning of word not the one in the middle.

[Yoichi]

@hsendel

But this will remove even hypen in " Unix-Based" word, no?

No, this will remove hyphen at the beginning of String and after period. Can you try with actual data?

Regards,

[hsendel]

@Yoichi

System.Text.RegularExpressions.Regex.Replace(strData,"(?<=^|\.\s*)-+","")

I didn’t remove hyphen & dash at the beginning of sentence :

[Yoichi]

Hi,

It’s replace method. regex pattern is (?<=^|\.\s*)-+

Regards,

[hsendel]

@Yoichi

(?<=^|.\s*)-+

OK Let me check.

[hsendel]

@Yoichi

System.Text.RegularExpressions.Regex.Replace(strData,“(?<=^|.\s*)-+”,“”)

This gives me a list of characters instead of words

[Yoichi]

@hsendel

a list of characters

This means String?
And your expression is not same as mine.(\ is lacked) Can you try to use as the following?

strData = System.Text.RegularExpressions.Regex.Replace(strData,"(?<=^|\.\s*)-+","")

Regards,