.csv problem

image

anyone know how to change the
9.06002E+15 here like this 906C0017110254992
format.
9.06002E+15 this happens when i have id that contains so many 0(9060020000000000)
im using ah .csv file. i tried to edit the format but when i save, close and open the file it always come back in this format 9.06002E+15
i can’t match few id’s because of this issue. please help.

Hi @ldiaz

Check out this XAML file in the thread

Regards
Gokul

1 Like

Hi,

If you use ExcelWriteRange or WriteRangeX, can you try to use Workbook-WriteRange as the following?

image

Regards,

i need to read the csv file and match id from other excel file . my problem is, i can’t match few id’s cause the id format is changed by excel to 9.06002E+15.

Hi @ldiaz

Have you tried with Format cell activity

image

Check out this thread

Regards
Gokul

we are using old version.
image

Can you tell us how the data will comes into CSV file? @ldiaz


this is my workfloww

Hi,

How did you input these data into the sheet?
Current data is not very good because it might be drop accuracy. For example, can you try to input the following 2 values?

9060020000000000
9060020000000001

Both will be “9060020000000000” due to digit accuracy.
So it might be necessary to review way to write data.

Regards,

hi im sorry for the late reply. when i tried to match ids
it matched when the file both file is .xlsx
but when i convert the 1 file to .csv i can’t find the 300+(.xlsx) ids that i want to match

the .csv file contains 150k ids thats why we convert the file to .csv cause the uipath can’t handle the file when it’s .xlsx format. when i tried to do find it using ctrl+F in excel i can’t see the ids.