How do I use split expression to split between date and value into another cells. I can’t figure out the expression to use “for each row in datatable”. The value on the right side is dynamic value. Can be decimal, 2 digit or can be 1 million digit. But the date is always static on the left while values is on the right side. How do I split them into column B (date) and C (value) just like picture below:
test4.xlsx (9.9 KB)
Really appreciate the helps
Read range activity reads the excel data into a table
Use For-Each Row to iterate rows
currentRow(1) = currentRow(0).ToString.Split(" "c)(0)
currentRow(2) = currentRow(0).ToString.Split(" "c)(1)
- Outside For-each just use a write range and write the same table back to Excel into the same sheet
Hope this helps.
Sorry, Im having error with this
@DTECH At what point please ?
Can you share an example input and output excel?
stopped on second assign (2.b)
Could you please show what did you do in that assign ?
Same as your step, read range → for each assign → write range
But it stop at 2nd assign
@DTECH can you try currentRow(0).ToString.Split(" “) & currentRow(0).ToString.Split(” ")
I am sharing a simple example that you can use. I hope it helps.
simpleExample.xaml (9.9 KB)
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.