Question
Incedo Inc
IN
Last activity: 21 Mar 2023 8:24 EDT
How can we get first value from text property having comma separated values in clipboard page
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
Accepted Solution
Updated: 21 Mar 2023 8:24 EDT
Bits in Glass
IN
@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.
Updated: 19 Mar 2023 4:52 EDT
Virtusa
IN
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
Incedo Inc
IN
@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
Bits in Glass
IN
@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.