Question

7
Replies
3169
Views
 Henry Allen (HenryA80)
Veteran Careers First

Veteran Careers First
US
HenryA80 Member since 2015 59 posts
Veteran Careers First
Posted: March 6, 2018
Last activity: March 7, 2018
Posted: 6 Mar 2018 12:47 EST
Last activity: 7 Mar 2018 13:04 EST
Closed

Expression Builder/Function in activity

MyPage.MyPage.Myvaluelist(21)

Myvaluelist(21) = ABC123

I am attempting to parse ABC123 so that only the number 123 is passed to PEGA using the Expression Builder in activity.

I tired substring but cannot seem to get it right.

MyPage.MyPage.MyValuelist(21) = Substring(ABC123,Int StartIndex=0, Int endIndex=5)

I get error saying:

-Invalid expression or reference: Operation "==" is not permitted on types: includedpage and integer

See Attachment

Data Integration Java and Activities
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.
Posted: 3 years ago
Posted: 6 Mar 2018 18:59 EST
Susan Liu (SusanLiu_GCS)
PEGA
Principal Software Solutions Engineer
Pegasystems Inc.
US

Hi,


Can you try the following?


MyPage.MyPage.MyValuelist(21) = @(Pega-RULES:String).substring(ABC123, 0, 5)


Thanks,


Susan
Posted: 3 years ago
Posted: 7 Mar 2018 13:04 EST
Henry Allen (HenryA80)
Veteran Careers First

Veteran Careers First
US

This record has 1 error(s) in 1 place(s) .


Source—


Invalid expression or reference: error Final Expression


 


(truefalse) can't be converted into the desired type (decimal)
Posted: 3 years ago
Posted: 6 Mar 2018 22:36 EST
Praneeth Purighalla (PraneethPurighalla)
PEGA
Lead System Architect
Pegasystems Inc.
IN

Try as Susan suggested. On a different note, if you want to extract 123 from ABC123, your start and end index arguments to substring function are incorrect.
Posted: 3 years ago
Posted: 7 Mar 2018 4:14 EST
Mohammad Asif Hasan (Asif Hasan)
PEGA
Senior Technical Solutions Engineer
Pegasystems Inc.
IN

Hi @HenryA80,


Thanks for posting on PSC.


You can go with the split function if you know the string structure and place of occurrence of numerals.


Alternatively, you can your own function with below code and use it in Expression Builder.


Input:- aInputStr


StringBuffer bufOutputString = new StringBuffer(aInputStr);


StringBuffer bufNewOutputString = new StringBuffer();


for (int i = 0; i < bufOutputString.length(); i++) {


if (!Character.isLetter(bufOutputString.charAt(i))) {


bufNewOutputString.append(bufOutputString.charAt(i));


}


}


return bufNewOutputString.toString();


 


Hope it helps in achieving your business requirement. Kindly notify if it does by marking this post as answered/helpful for larger Pega audience and tracking purposes.


 


Regards,


Asif