Need to get the last 4 digits from unstructured text lines, how?

[#1]

Hi all,

i got a column with likes that includes both text and numbers:

looks something like that (the text is random here but format/structure is the same though):

Bob Bobinald on the tree, 1234

Oranges, Mike!!!! #palms, 1111

Going on vacation soon, 2222

blah blah... blah, 3333

some other text here, 1234

(the text in lines is without any structure.. and sometimes includes different symbols as well... commas, dots etc.. but it always ends with a comma before the last four digigts - if it can help)

i need to get those last 4 digit numbers into a seperate collumn.

what would be the best way to do it?

Thanks in advance for your help.

[sivarajs · Accepted solution]

right('Your text here',4)

you can use in script like

load *, right('Your text here',4) as new_field

from test.qvd;