Question
HCLTech
US
Last activity: 3 Sep 2021 12:11 EDT
Parse CSV string with multiple rows into a Page list
I have a CSV string with multiple rows, 1st row is header and from 2nd row onwards the actual data. The value is available on a property of type text. Need to convert this into a page list, for the below example there should be 3 page list created with properties name,age,phone_no &contact_group. Let me know if anyone have implemented this, Thanks in advance.
"name","age","phone_no","contact_group"
"jon","22","78964784948","Default"
"snow","23","78964784949","Default"
"jeff","24","78964784949","Default"
pxPageListFromStringCSV will not work as it will covert each value before , to a seperate pagelist
Accepted Solution
Updated: 3 Sep 2021 12:11 EDT
Clocklike Minds
PL
something like this can be achieved easily in a few steps:
1) Call a Parse Delimited rule which will split it into rows
2) map it to a property list
3) loop thru the list, skip the 1st iteration and apply another parse delimited rule to properly parse each line (each element in the list created in the previous step)
Hope it'll help you ;)
TATA Consultancy Services
IN
@Dharanidharan Please try to use pxPageListFromStringCSV function. Its helps for your requirement.
HCLTech
US
@Nadimuthu T pxPageListFromStringCSV will not work for my use case, the use for this function is different. Find below example
Name1,Name2,Name3
This function will create 3 pagelist and will map the values to a property (in this case say .Name).
My requirement is that each value should be mapped to separate property and should consider multiple rows as well.
Accepted Solution
Updated: 3 Sep 2021 12:11 EDT
Clocklike Minds
PL
something like this can be achieved easily in a few steps:
1) Call a Parse Delimited rule which will split it into rows
2) map it to a property list
3) loop thru the list, skip the 1st iteration and apply another parse delimited rule to properly parse each line (each element in the list created in the previous step)
Hope it'll help you ;)
Updated: 3 Sep 2021 12:11 EDT
HCLTech
US
@KDurczynski Thank you for the quick response, This works!