While using excel if we are having some data like Delhi, Bangalore in one column can we replace comma with or in Excel sheet
You can do it in multiple ways
in excel you can go to data tab on ribbon and select Text to column, then you can choose the delimiter as “,” ans then you’ll get the values splitted
in UiPath →
You can read the data using Read Range
Loop it using For Each Data Row
then for that column you can take the value in a variable, using row(“columnName”).tostring
row is the for each data row variable, can be different for you
then you can use split function
This will give you an array, that array element csn be accessed using their index
and so on
Welcome to Community!
I have created a sample work flow based on your use case!
ColumnValue_Replace.xaml (6.5 KB)
actually that file is not opening
how can i refer plz give the solution
i did this with bala reva there we can find and replace the text but its not giving the output and also there were no errors just executing the bot but in the excel there were no changes
Refer the steps below.
Read Range the Excel using Read range Activity.
For Each row in datatable of read range DT
Currentrow(“YourColumnwithComma Separted Value”)=if(CurrentRow(“YourColumnwithComma Separted Value”).ToString.contains(","),CurrentRow(“YourColumnwithComma Separted Value”).ToString.Replace(","," or"),CurrentRow(“YourColumnwithComma Separted Value”).ToString)
Then Write Range with Read range path and read range Dt.
thank you so much for ur efforts about this doubt.i will work on it if i get the answer i will intimate
Does its helps for you?
yeah ,will u please help me regarding my doubts can u share ur knowledge
may i know ur contact details to communicate
Please mark solution to the post which you find useful and close this thread so it may helpful for others!
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.