Hi Team ,
My requirement is i need to replace different types double quotes.
Ex:“2,686.000” —value in data table
2.686,000 ------replace value “,” replaced by “.” and “.” should be replaced with “,”
in a single string .
In similarly we have do for multiple column in excel column’s
attaching excel for references .
sample data.xlsx (68.6 KB)
After performing string operations in data table we have to convert the dt to CSV file .
Thanks ,
Suresh.T
Hi Yoichi ,
Thanks for quick response …
I have checked above solution but still some issue has there .Can you please help.
File which we converted manually excel to CSV data look this .
By using our solution it is some difference format with string .
When i opened the file has CSV format .
There is difference in csv data .
Ex:-1,54,500 —in current CSV .
It should be 154,500 .
Can you please help me this .
Thanks ,
Suresh .T
Hi,
Your original format seems semicolon separated value format. So for now, can you try to set Semicolon at Delimiter property in WriteCSV, as the following?
Regards,
hello @Thumu_Suresh
You can use read range activity to get the data in excel to datatable. Then use output datatable to convert datatable to string. Then use replace method to repalce the “,”.
YOURSTRING.REPLACE(“,”,“.”)
Then use text to datatable activity to convert back to datatable.
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.
