PrajaktaV1633 Member since 2018 8 posts
Infosys Ltd
Posted: 1 year ago
Last activity: 1 year 7 months ago

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***

Case Management Reporting
Moderation Team has archived post
Share this page LinkedIn