topic Sub string in App Development

Sub string

nihhalmca — Tue, 06 Dec 2022 14:17:49 GMT

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 — Tue, 06 Dec 2022 15:41:50 GMT

Maybe this

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

vinieme12 — Wed, 07 Dec 2022 06:50:14 GMT

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

nihhalmca — Wed, 07 Dec 2022 10:53:04 GMT

Thanks, its working.