using regular expression in function
Posted: Fri Mar 03, 2017 4:52 pm
I'm trying to use a regular expression in the lastposition and substring functions to separate a word into two values based on where the A-Z ends and the numbers begin:
CAPMO0330201400 needs to be CAPMO & 0330201400
I thought the first substring would work like this:
${Substring(nonrenewcsvrow[1],1,LastPositionOf(nonrenewcsvrow[1],'[A-Z]'))}
but I am getting -1 for LastPositionOf, so are regular expressions not allowed or do I have the syntax wrong?
CAPMO0330201400 needs to be CAPMO & 0330201400
I thought the first substring would work like this:
${Substring(nonrenewcsvrow[1],1,LastPositionOf(nonrenewcsvrow[1],'[A-Z]'))}
but I am getting -1 for LastPositionOf, so are regular expressions not allowed or do I have the syntax wrong?