using regular expression in function

If you have a new question you’d like our support staff to post a response to, please visit our customer community, Data Security Insiders, to pose the question in our Discussion Boards. We have a thread “Ask Our Tech Experts” that our support team monitors on a regular basis, or you can start a new discussion where other GoAnywhere users and support staff can weigh in. Log in or create your new account at

If you need an immediate response, please create a support ticket or contact our support team by email at [email protected].
3 posts Page 1 of 1


Posts: 8
Joined: Fri Feb 24, 2017 9:40 am

Post by fthomas » 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:


but I am getting -1 for LastPositionOf, so are regular expressions not allowed or do I have the syntax wrong?


Support Specialist
Posts: 592
Joined: Tue Jul 17, 2012 2:12 pm
Location: Phoenix, AZ

Post by Support_Rick » Fri Mar 03, 2017 4:58 pm
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.

Rick Elliott
Lead Solutions Consultant
(402) 944.4242
(800) 949-4696


Posts: 8
Joined: Fri Feb 24, 2017 9:40 am

Post by fthomas » Sat Mar 04, 2017 8:43 am
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.
3 posts Page 1 of 1