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?
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].
- Support_Rick Offline
- Support Specialist
- Posts: 590
- Joined: Tue Jul 17, 2012 2:12 pm
- Location: Phoenix, AZ
- Contact:
Re: using regular expression in function
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
Re: using regular expression in function
ok, well then that's a feature request! And/or is there a way in a ModifyRowset to split a column in to two columns separating the alpha from the numeric? If not, I can do this in the SQL.