Parse CSV string with multiple rows into a Page list

General
, , ,
1

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

2

@Dharanidharan Please try to use pxPageListFromStringCSV function. Its helps for your requirement.

3

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

4

@Dharanidharan

something like this can be achieved easily in a few steps:

  1. Call a Parse Delimited rule which will split it into rows

Split lines.png
Split lines.png555×304 7.07 KB

Value List.png
Value List.png1180×166 9.3 KB

  1. map it to a property list

  2. 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 :wink:

5

@KDurczynski Thank you for the quick response, This works!