Activity "read csv" changes the content of the cell

Help Studio
, , ,
1

Hi,

In excel I have numbers that consist of 14 digits. After use activity “Read csv” their content is changing.

Before:
image

After:
image

Is there any way to prevent this?

2

make that excel column’s datatype as number

That shortening is done due to excel’s auto formatting

3

@rahulsharma

Column datatype is general.

So nothing can be done about it?

4

Hi
Have a view on this thread

Cheers @Paulina_x

5

Pardon! The format should be Number and with no decimal

image
image1030×562 25.6 KB

There is a custom activity to do so, check that out, from the master @balupad14

1 Like