Text between characters

[rajinikanth]

Hi all,

I have a filed where the filed has ID and Text as below.

ID	Text
IMO67	%%AAA%%  %%A123%% %%AAA%%  %%A456%%

I want data as like below

ID	Text1	Text2
IMO67	A123	A456

[vchuprina]

Hi,

You can try something like this:

PurgeChar function removes unnecessary symbols in your case is % and space.

Mid and Right functions allows to select correct symbols 

LOAD
  ID,
  Mid(PurgeChar(Text, '% '), 4, 4) AS Text1,
  Right(PurgeChar(Text, '% '), 4) AS Text2;
LOAD * Inline[
ID, Text
IMO67, %%AAA%% %%A123%% %%AAA%% %%A456%%
];

Result:

Regards,

Vitalii

[rajinikanth · Accepted solution]

Thanks it worked out for me, also can you help me on the below link which is quite similar.

[vchuprina]

Hi,

If it's possible please mark correct answers as "solutions".

Also, I don't see the link, please send it again.

Regards,

Vitalii

[rajinikanth]

https://community.qlik.com/t5/New-to-Qlik-Sense/Extract-specific-from-a-field-value/m-p/1922744#M204...