Manipulate csv data as number in a collection

[yves.d...@gmail.com]

Hello,

I've loaded a csv file into a collection using import_objects. My problem is that all data are treated as text : number in the csv file are considered as text. As a result, even if I select the type number in the collection report, I can not use >, <, between, etc. functions of the standard filter.

Is there any workaround ?

regards
Yves

[Bidisha Das]

Hi,

You can use :${import_objects("File id","Collection name",{"parse_numbers":["Column header name",Column index]},true)} to save a number data as number and not as string in Collection.You will be then able to use <,> and between filter operators.

Thanks & Regards

Bidisha

[yves.d...@gmail.com]

Thanks Bidisha