1 of 1 people found this helpful
If your text strings all follow the same format where it is the last word you need to extract the 3 digit numbers from.. you might be able to do it this way:
LEFT(SPLIT(<insert string field name>, ' ', -1), 3)
and hence not worry about regexp. This method assumes you are using a datasource that supports the SPLIT function. Some generic ODBC connections will not support it.
Thank you Srinidhi, much appreciated your help.