using regular expression in function
Post any question you may have in regards to GoAnywhere MFT and let our talented support staff and other users assist you.
If you need a quicker response, please create a support ticket via the customer portal my.goanywhere.com or contact our support team by email at [email protected].
If you need a quicker response, please create a support ticket via the customer portal my.goanywhere.com or contact our support team by email at [email protected].
3 posts
Page 1 of 1
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?
- Support Specialist
- Posts: 590
- Joined: Tue Jul 17, 2012 2:12 pm
- Location: Phoenix, AZ
-
The -1 is saying that the value '[A-Z]' isn't found to determine a lastPositionOf.
The function doesn't allow regex to be utilized this way.
Sorry...
The function doesn't allow regex to be utilized this way.
Sorry...
Rick Elliott
Lead Solutions Consultant
(402) 944.4242
(800) 949-4696
Lead Solutions Consultant
(402) 944.4242
(800) 949-4696
3 posts
Page 1 of 1