Created 05-27-2021 11:27 AM
I am trying to process a CSV file and convert it to a JSON in a specific format. My CSV file is as follows
START
PI,0010002,25,king,address,phone
PE,3.2,company1
PE,1.9,company2
STOP
START
PI,0010003,25,prince,address,phone
PE,3.2,company1
PE,1.9,company2
STOP
I want help in extracting records from START till STOP. I was able to do the JSON conversion.
Created 05-28-2021 09:14 AM
Want to get a detailed solution you have to login/registered on the community
Register/LoginCreated 05-28-2021 09:14 AM
Want to get a detailed solution you have to login/registered on the community
Register/LoginCreated 06-03-2021 05:32 AM
@Prajeesh10 Has your issue been resolved? If so, please mark the appropriate reply as the solution, as it will make it easier for others to find the answer in the future.
Created 11-28-2022 05:56 AM
id, name, balance, join_date, notes
1, John, 48.23, 04/03/2007 "Our very
first customer!"
2, Jane, 1245.89, 08/22/2009,
3, Frank Franklin, "48481.29", 04/04/2016,
the logic may fail in the above case, if column contains multiple rows.