Seperating text

Help
1

Hi,

I am facing issues with splitting the data from the below excel screenshot,
actual thing is from the 4th column MRP i need to split depend upon the “Rs”,so wherever the first Rs comes i need to move it to next column.

so i will try uploading the xaml file if you required can someone help me

image
image753×447 14.2 KB

1 Like
2

Hi @Karthik_Kulkarni

Use assign =row(“MRP)=row(“MRP”).ToString.replace(“Rs”,”") and then check it

Thanks
Ashwin S

3

Fine
Hope these steps would help you resolve this
—use excel application scope and pass the file path as input
—Inside the scope use READ Range activity and get the output with a variable of type datatable named outdt
—now use a ADD DATACOLUMN ACTIVITY where mention the datatable name and the columnname we want so that it will be added to the last of the current column
—now use a for each row loop and pass the above variable as input
—Inside the loop use a if condition like this
row(3).ToString.Substring(0,2).ToString.Contains(“Rs”)
If true it will go to THEN part where we can use a assign activity like this
row(4) = row(4).ToString

Cheers @Karthik_Kulkarni