I have a spreadsheet with some numbers, these numbers are divided by the character “|” and I would like to separate these numbers and paste in three different columns.
Example of how the numbers are:
86|531|1664494|
26|531|11471351|
7|531|1726089|
36|531|4283273|
65|531|6872462|
1|531|5038631|
33|531|3400366|
Thanks!
@vinicius.botelho - Please check this…
So instead of hardcoded value, please pass row(“yourColumnname”).tostring…add this to datarow…if you are if you always receive 3 values then create 3 columns before that, use that add datarow…
Hello You can also use an Activity call Genereta Table, with that Activity the output will be a DataTable, In the Activity you can specify what is the separator
It worked! Thank you for your help @prasath17
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.