How can we get first value from text property having comma separated values in clipboard page

User Experience
, , , ,
1

Hi All,

we have one property of type text, having comma seperated values.

Please let me know, how can we get the value from those values.

For Instance.

EligibleEmployees = 3402,4034,9045,2367,7585. .

Please help me on this

Regards,

Surya

2

@SuryaYanamandra if you want the first value alone, then use whatcomesbeforefirst() function. Pass ', ’ as the character.

If you want to get all the values in this csv. Use parse delimiter rule, using apply-parse-delimiter in activity. Use , as the delimiter. It will convert all the values into a value list. Use build list option in delimiter rule. Then you will have access to all the values.

3

Hi @SuryaYanamandra,

Use this Function

@(Pega-Gadgets:pxDataManipulate).pxPageListFromStringCSV(stringCSV,inputPageList, “property”, “pageClass”)

Example:

In Data Transform

Set Target as Param.Dummy

Source as @(Pega-Gadgets:pxDataManipulate).pxPageListFromStringCSV(.EligibleEmployees,.Employee, “.EmployeeID”, “ABC-Data-Employee”)

Thanks

4

@UdaySimhaReddy And @Anoop Krishna Thankyou for the response, here EligibleEmployes is the text type of property, where we are saving all the employeeids with comma seperated values

5

@Anoop Krishna Thanks Anoop, It is Working. . Please ignore my comment below

6

@SuryaYanamandra ya right. When you pass that property to parse delimiter rule, you will get those comma value seperated values in value list.

In DT or activity,

Set Temppage.pyNote = . EligibleEmployees

In parse delimiter rule use the property above property to be set to valuelist property(referred in parse delimiter rule) you have created. Option should be build a list in parse delimiter rule.

In activity use apply-parse-delimiter rule. If you are using activity, call this activity using pxexecuteanactivity().

Your value list property will have all those comma seperated values.