Sub string

[nihhalmca]

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.

[BrunPierre]

Maybe this

If([String Field] Like '*X*', TextBetween([String Field],'(',')'),[String Field]) as [Transformed Field]

[vinieme12 · Accepted solution]

Table:
load coalesce(TextBetween(ID_text,'(',')'),ID_text) as ID inline [
ID_text
10 XXXX (22P1)
44L1
5555
20 XXX XXXX(44C5)
];

[nihhalmca]

Thanks, its working.