Hi Experts
How would I split a string which I made a regex for and write it out on a excel worksheet.
Hi,
To split a string, you need to use the .Split() function. For example, in strData.Split(“,”.ToCharArray), you have split with the “,” character and the output is a list. So be careful to have declared a list at the left.
To write it in an Excel, it depends what you wants exactly. You can access the elements like you’ll do for a list.
Good luck!
Best regards
1 Like
the .Split is giving me an error because it is not an ienumerable
As shown in the screenshot
Ok, you mean that your variable " valueSet " is not a string. Is your “Matches” activity giving you more than 1 result? If yes, then you’ll need to iterate through the results and do the split for each element. Use a “For Each” activity with TypeArgument " System.Text.RegularExpressions.Match ".
1 Like
The matches activity gives me 1 string
If your Regex gives you always one result, then you don’t need a loop. Just use : valueSet.ElementAt(0).ToString().Split(“;”.ToCharArray) . Replace the “;” with the character you want to do the split.
1 Like
Is splitValueCkNo a list? You have this error because there is a difference of types. At the right you have a list because when you do a split, it separates the string and the output is a list of strings.
Please double check if your variable has the right type, it should be “System.String”.
Good luck
1 Like
what do I search in browse for a system.string
Nevermind I got it! I have one more question. How would I write that to a write range since its an ienumerable
If your concern is only to write in an Excel, you can use the Write Cell activity and loop through each element of your IEnumerable, with a counter to go to the next row (be careful to initialize the counter with the value 2 because there is a shift between UiPath & Excel).
If you want to use Write Range activity, then you need to convert your IEnumerable to a datatable. I’ll probably use the “Add Data row” activity inside a loop which loops the IEnumerable. Please look at the example below:
1 Like
Is it ok if you can show me the add data row build data table method?
At the top (not shown in screenshot) I made a datatable with 1 column how would I use the regex I split and write it
Yes of course. This is how it works:
When you want to use a datatable, you always need to build it by using the Build Data Table activity.
When you click on “DataTable…”, you can add the columns you want by clicking on the “+” button, here in the example I just declared one column corresponding to your Regex.
After building your datatable (don’t forget to put the output name of your datatable), you can iterate through your regex, and use the Add Data Row activity, as below:
As you can see, I have put " {item}" in the ArrayRow part.
This example shows you how to write it line by line, I hope this is what you need.
1 Like
ashokkarale
MD_Farhan1
Ajay_Mishra
postwick
Dheerendra_vishwakarma
Anil_G
chandreshsinh.jadeja
Gautham_Pattabiraman
vrdabberu
aravindbalineni123