January 18, 2023, 6:45pm
I have a csv file and the data do not appear correctly, my system separator is ( decimal " , " thousand " . " . If i change it to ( decimal " . " thousand " , " then data appear correctly.
I would like to avoid changing the system separator ( or from excel options) because it will probably affect other processes that run on that server.
Is it possible to do it without chaning system separators?
January 19, 2023, 9:11pm
The csv file has also characters and when i open it ( from Studio or manually) has the following format in one column:
232591;S03346 ;ÊÁ2463987;GAMING DEVICE;2119607777;2023-01-11-10.02.07.000000;2023-01-12-08.51.25.000000;+0
If i change the decimal and thousand separator ( manually from excel options ) then the data separated by column correctly( comma means that the data of the row is in the different column) :
232591 , S03346 , ΚΑ2463987,GAMING DEVICE,2119607777, 2023-01-11-10.02.07.000000,2023-01-12-08.51.25.000000,0,0,0,0,0,0,0,0,0,20230112
January 20, 2023, 10:17am
I found the solution.
I used the following activity at the beginning of the workflow :
After that i use ReadText File activity ( Endoding :“Windows-1253”)
Replace “+” with space and next step is to generate datatable from string ( format : csv ,Column separators : semicolon).
Last step is to write the datatable to the new excel file.
January 23, 2023, 10:18am
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.