Hi all, I import the below from a txt.file in to Ui Path
My goal is to split it all using the | and then export the result in to an Excel file so each value is in it’s own cell (ID in cell A1, Name in B1, Occupation in B3, 101 in A4 etc). All for learning purposes.
I believe I can use split.(Var, Environment.newline) and then split.(Var, “|”) to split each line up.
Is there a way I can combine both these functions in to one string? I’m then struggling to get the new data in to some sort of string array so I can then export it to an Excel file (or datatable etc)
Would I have to use a ‘For Each’ or can I do it all in ‘Assign’ activities?
A few different learns for me here! Thanks for any help in advance,