Decimal and thousand separator system, CSV File

Help Studio
, , ,
1

Hi ,

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?

Thank you

2

@m.fokas

Please check this

Cheers

3

Hi @m.fokas,

You can try below thing,

image
image1588×890 63 KB

output
image

  • It works as Whatever separator you provide in below variable
    nfi.NumberDecimalSeparator = “,”
    nfi.NumberGroupSeparator = “.”
4

Hi ,

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

Thank you

5

I found the solution.

I used the following activity at the beginning of the workflow :

System.Threading.Thread.CurrentThread.CurrentCulture=new System.Globalization.CultureInfo(“el-GR”)

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.

Thank you

6

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