Question
Infosys Ltd
IN
Last activity: 5 Mar 2019 5:47 EST
Extract number between special character using function alias
Hi, I want to extract number (95) from this case ID - ORG_CR_95_FY2018. Number can be of any length. Also i want to achieve this using function alias only as i need to use this in report definition for sorting of case IDs on numerical basis. I have used below approach: Cast(SUBSTR('ORG_CR_95_FY2018', instr('ORG_CR_95_FY2018', '_', 2)+1, instr('ORG_CR_95_FY2018','_', 3)-1) AS INTEGER) But it is not working. Can anyone suggest me how to achieve this. Thanks and Regards, Prajakta
***Edited by Moderator: Pallavi to update platform capability tags***
Pegasystems Inc.
IN
Hello Prajakta,
I believe your issue is sorting issue of case ID. But with the below solution, it is not directly applicable as the case ID format is different for you.
The below article has a similar requirement:
https://collaborate.pega.com/question/substringfunction-parse-date
You can try making use of the below ootb function aliases in the similar manner.
- pxSubstring
- pxFind
I hope this helps a bit.
Thanks!