Question

7
Replies
2804
Views
HenryA80 Member since 2015 52 posts
Veteran Careers First
Posted: 2 years ago
Last activity: 2 years 6 months ago
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
Close popover
Moderation Team has archived post
Posted: 2 years ago

Hi,


Can you try the following?


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


Thanks,


Susan

Posted: 2 years ago

I will give this a try.

Posted: 2 years ago

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: 2 years ago

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: 2 years ago

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


 

Posted: 2 years ago

Thanks I will give this a try...
Share this page LinkedIn
Copied!