Reg Expressions In Progress

Jeevan23

New Member
Hi,

Is Progress 9.1e support regular expressions.
Actually i need to divide the Account Number in different parts based on regular expression pattern, how can i do this in progress 9.1e?

if progress supoorts reg expressions, please give me the guidance to use reg expression in sql query.

Thanx.
 
Progress doesnot support Regular expression. For what it is worth, I would bypass this limitation by formatting the account number (since Account Number should be fixed length) into a set format!
For example:
<Code> STRING("ABCD123456789", "XXXX-(999)999-9999") </Code>

After that if you want to parse the string, you are free to do so.
 
Last edited:
Back
Top