Extract only offers email text type

When I use the “Extract” function, I am only offered a text type of “email”, and components only appropriate to email addresses, although the field in use is of type text. Is this a bug, or am I missing something?

I wish to extract 3 numbers from different positions in a string and use these to form a date. Using combinations of truncate and truncate to I can extract the numbers, but I am sure there must be a more elegant way to do this. All suggestions gratefully received.

You may well want “Extract wih regex” ?

This topic was automatically closed after 14 days. New replies are no longer allowed.