Extract numbers from start of string and remove from original string

Anonymous — Thu, 22 Nov 2018 22:36:41 GMT

I am looking to remove the numbers from (if there are numbers) from the start of a string - then put those number into a new column. As well as that remove those numbers from the original string.

There may be records that do not contain numbers as well , so I don't want it bombing out.

e.g. numbers could look like (of course there may be other combinations - but this is what I have seen thus far)

ORIGINAL FIELD	NEW FIELD 1	NEW FIELD 2
1. xys	1	xys
1.xvy	1	xvy
1abc	1	abc
1 abc	1	abc
1)rt567	1	rt567
1) asdf	1	asdf
1.1sdaf	1.1	sdaf
1.1 werer	1.1	werer
1.1.sfsf	1.1	sfsf
1.1.sdsdf	1.1	sdsdf
1.1)sdffs	1.1	sdffs
1.1) asdfds	1.1	asdfds
10 adasd	10	adasd
10sdfdsf	10	sdfdsf
10)sdfds	10	sdfds
10.1 werwer	10.1	werwer
10.1sfsf	10.1	sfsf
10.1)wefwef	10.1	wefwef
10.sfsdf	10	sfsdf
10. werewr	10	werewr

Thanks in advance talented Talenders

topic Extract numbers from start of string and remove from original string in Talend Studio

Extract numbers from start of string and remove from original string