Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
I need to get 4 letter code from string.
For example:
10 XXXX (22P1)
44L1
5555
20 XXX XXXX(44C5)
Expected Result :
22P1
44L1
5555
44C5
Thank you.
Table:
load coalesce(TextBetween(ID_text,'(',')'),ID_text) as ID inline [
ID_text
10 XXXX (22P1)
44L1
5555
20 XXX XXXX(44C5)
];
Maybe this
If([String Field] Like '*X*', TextBetween([String Field],'(',')'),[String Field]) as [Transformed Field]
Table:
load coalesce(TextBetween(ID_text,'(',')'),ID_text) as ID inline [
ID_text
10 XXXX (22P1)
44L1
5555
20 XXX XXXX(44C5)
];
Thanks, its working.