Csv to excel comma contains columns error

Help Studio
, ,
1

Dear All,

When I use csv to excel file converter in uipath, some value contain (,) within the CSV. such as

image

So the converted columns are in the wrong column due to (,) in the xlsx file.
image

This is my sample activity for that. Thanks.

image
image1266×457 18.9 KB

Kindly suggest what can i do for that one. thanks

2

This link may help you, @Htwe_Ko_Ko_Wynn

3

Hi Manish,

Thanks for your solution but this doesn’t meet my requirement. As CSV file already contain comman. Thanks.

4

@Htwe_Ko_Ko_Wynn Can you follow these Stpes and Check if it works?

  1. Use Read Range for the Excel file and get the Output Datatable.
  2. Use Write to CSV Activity and Supply the Output Datatable to it.

If this Doesn’t Work, we might need to Convert the Comma in your values to some other delimiter , and then Convert it back while retrieving.

5

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.