Split on caps

Help Studio
,
1

Hello,
How do i split a variable by caps? Example: JohnDeere → John Deere?

2

@anon53238024

Please check below thread for your reference.

1 Like
3

Hi @anon53238024

Better use regular expressions ex ([A-Z][a-z]*)
Refer below query

4

Hello @anon53238024,

You will find the answer here. In the solution they refer to Regex.Replace() , ensure you use System.Text.RegularExpressions.Regex.Replace() in UiPath.

Regards,
Nithin

5

This will give you the array after splitting the entire string into substrings after splitting with capital letter, so you can get them individually.

System.Text.RegularExpressions.Regex.Split(str,“(?<!^)(?=[A-Z])”)

else if you want the first string give it as

System.Text.RegularExpressions.Regex.Split(str,“(?<!^)(?=[A-Z])”)(0)

2 Likes
6

Use an assign activity accepting an String variable and expression system.Text.RegularExpressions.Regex.Split(dummy,“(?<!^)(?=[A-Z])”) where dummy is the string variable which holds your input string.
Please find the attached built sequence for easier usage
Dummy.xaml (4.9 KB)

8

Here in this “0” represents the first element and 1 represents the second and so on…

System.Text.RegularExpressions.Regex.Split(str,“(?<!^)(?=[A-Z])”)(0)

1 Like
9

Thank you!

1 Like
10

Sometimes there will be names that are not two names combined. Ex only John.
I use:
System.Text.RegularExpressions.Regex.Split(str,“(?<!^)(?=[A-Z])”)(0) to get the first item,

and:
System.Text.RegularExpressions.Regex.Split(str,“(?<!^)(?=[A-Z])”)(1) to get the second item.

If i only have a name that is not a combination of two names, an error will occur. How do i take this into account?

11

Better to assign the entire values to a string array after splitting using a assign statement like

strArray = System.Text.RegularExpressions.Regex.Split(str,“(?<!^)(?=[A-Z])”)

where you will get the length of the array whether you have only one or two. Using that, you can loop through the values using for each and then you can continue with the next flow.

Else try catch is another option

2 Likes
12

How do i get the length? When i try to “write line” the results it is just returning “System.String”

13

if strArray is your array, you will get the length as strArray.Length and if you want to use it in write line, then strArray.Length.ToString as write line supports only strings

2 Likes
14

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.