How to split string using regex

[Lalitha_Selvaraj]

Hello all,
Can anyone know how to split the string using regex where whitespace as a delimiter?

Input string:
xxx 0190 a b c

Expected output:
xxx
0190
a b c

[Yoichi]

Hi,

Can you share if there is a rule not to split “a b c” part to a, b and c?

Regards,

[Lalitha_Selvaraj]

No @Yoichi . There is no rule. Main issue is I need to split string based on whitespace using regular expression.

[Yoichi]

Hi,

How about the following?

System.Text.RegularExpressions.Regex.Split(yourString,"\s+")

Regards,

[ppr (Peter Preuss)]

@Lalitha_Selvaraj

ain issue is I need to split string based on whitespace

then above mention is not conform with expected output:

…
…
a b c

as here the space for splitting was not applied.

We agree with:

@Yoichi

if there is a rule not to split “a b c” part to a, b and c?

[vrdabberu (Varunraj Dabberu)]

Hi @Lalitha_Selvaraj

Assign -> Input = "xxx 0190 a b c"

Assign -> Output = System.Text.RegularExpressions.Regex.Matches(Input.ToString, "[A-Za-z0-9]+")

Message Box -> String.Join(Environment.NewLine, Output.Cast(Of Match)().Select(Function(m) m.Value.Trim()))

Input is of DataType System.String. Output is of DataType System.Collections.Generic.IEnumerable(System.Text.RegularExpressions.Match)

Regards

[Lalitha_Selvaraj]

I have added a b c its because some times the string looks like “firstname middlename last name” . so i have to capture all the strings(firstname, middlename, last name)

[Jayesh_678 (Jayesh)]

Hi,

Input:-

Output:-

Xaml file:-
Main.xaml (8.1 KB)

If this works for you, please mark it as a solution, so others can refer the same.
Thanks

[ppr (Peter Preuss)]

@Lalitha_Selvaraj

so i have to capture all the strings(firstname, middlename, last name)

so it is not a consequent split on space.

In such cases we would check more on reliable patterns and can use techniques of inserting delimiters like:

so we can split on | afterwards and would also trim the splits

[Lalitha_Selvaraj]

Hi @ppr . Thanks. Can you explain more in detail. if possible, can you post the code for reference.

[ppr (Peter Preuss)]

@Lalitha_Selvaraj

can you post the code

Have a look at this series:

done within:
Understanding the 6 Debugging Panels of UiPath in the easiest way possible! - News / Tutorials - UiPath Community Forum

And feel free to break it down in smaller sub parts

[CheatSheet] - System.Text.RegularExpressions | RegEx

This CheatSheet introduces the basic use of regex functions. With further examples also special cases are presented. Introduction From the namespace System.Text.RegularExpressions following methods are offered: Regex.Match Regex.Matches Regex.isMatch Regex.Replace Regex.Split A simple usage for example would look like this: [grafik] Recommendation: add System.Text.RegularExpressions to the imports: [grafik] it allows to use the shortened statement, as the namespace part can be ommited…

[HowTo] LINQ (VB.Net) Learning Catalogue

This topic references the different Learning HowTos related to LINQ. It will be updated on new published HowTos as well LINQ Learning: Topic LINK First Start with LINQ [HowTo] - First Start with LINQ (VB.Net) Exploring the LINQ universe [HowTo] - Exploring the LINQ Universe (VB.Net) Operator [HowTo] Overview Topic LINK Where [HowTo] LINQ - First Start # Where Operator Select work in progress Any [HowTo] LINQ – First Start # Any Operator All [HowTo] LINQ – First Start…

[Lalitha_Selvaraj]

Thanks @ppr . Its working.

[ppr (Peter Preuss)]

@Lalitha_Selvaraj

Its working.

Perfect, so the topic can be closed
Forum FAQ - How to mark a post as a solution - News / Tutorials - UiPath Community Forum