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.