Question
Upc
CO
Last activity: 8 Mar 2023 10:36 EST
Comparation of string of strings
Hi team
I am very new in pega. I am need to do a comparation of two string of string values with comma separators to see what element of the first one are present and missing in the second one, doesn’t matter the order of the words.
I am trying to do it via data transform(there I have more steps)
I declare The first string as
param.list=“María , Martha, Mercedes, Megan”
I build the second list extracting and concat one value present in a data page, it have the same structure
param.list2=“Mercedes, Martha”
I need help to clarify how I can do the comparation between the both string of strings, in a way that allow me know that
Mercedes and Martha are present in the second list, Maria, Megan are missing
I really will appreciate your knowledge and time
Regards,
Updated: 8 Mar 2023 11:15 EST
Bits in Glass
IN
@StefaniB16783464 Directly comparing these 2 csv string list would not be possible. You can follow the below approach->
You dont have to convert your 2nd list to csv string list, instead you can convert your 1st csv string list to pagelist using pxPageListFromStringCSV function. You can keep both the list as list itself and you can loop 1st pagelist, get each name and do IsInPageList with 2nd pagelist. So what it does is, each of the name in the 1st list will be checked against all the names in the 2nd list. IsInPageList gives boolean output(true or false), with that you will know if that name exist or not.
NCS Pte. Ltd
SG
Hi @StefaniB16783464: Firstly, both of your list of names should be parsed based on the delimiter. You can use either pxPageListFromStringCSV to form tokenize the string and frame pagelist (or) apply-parse-delimited method in activity to parse the data to build a list. Once the data is tokenized, you can use logics of functions like isinpagelist to validate.
If you know which will be the master list, then you can tokenize only the master and can use contains functions against the other string.
Thanks.