topic CSV to collection dropping zero in Product Forum

CSV to collection dropping zero

Neel1 — Mon, 21 Aug 2023 09:56:00 GMT

Hello - While reading csv as collection, noticed that zero in the end is getting dropped.

After from writing a macro - is there any solution w.r.t get CSV as collection.

input looks like this :

D;1;206.050;2 where in collection 050 is coming as 05.

------------------------------
Neeraj Kumar
------------------------------

RE: CSV to collection dropping zero

dochrymuk — Mon, 21 Aug 2023 11:21:00 GMT

Hi Neeraj Kumar,

You can try to use action in Utility - Strings where you have to provide CSV value as a Text.

------------------------------
Dawid Ochrymuk
Manager
KPMG Poland
------------------------------

RE: CSV to collection dropping zero

Mukeshh_k — Mon, 21 Aug 2023 11:26:00 GMT

Hi @Neeraj Kumar : Can you try doing Utility File Management - Read All Text from File and then do Get CSV as Collection :

------------------------------
Kindly up vote this as "Best Answer" if it adds value or resolves your query in anyway possible, happy to help.

Regards,

Mukesh Kumar - Senior Automation Developer

NHS, England, United Kingdom, GB
------------------------------

RE: CSV to collection dropping zero

Neel1 — Tue, 22 Aug 2023 13:11:00 GMT

Mukesh Kumar - This one worked . i used the updated VBO of utility- strings. thank you.

------------------------------
Neeraj Kumar
------------------------------