CSV to collection dropping zero

[Neel1]

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
------------------------------

[dochrymuk]

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
------------------------------

[Mukeshh_k · Accepted solution]

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
------------------------------

[Neel1]

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

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