Extract specific from a field value

[rajinikanth]

I have text as below in a field value highlighted in blue.

"Enter the subject, choose a Board and ask away! You might just find a similar question that has been answered.

%%ABC%% World is approaching! Take your data to the next level %%DEF%%and similar $$123$$

New solution %%IJH%% Timetable %%XYZ%%"

I want to extract all values starting with between %% as below 

Field

ABC

DEF

IJH

XYZ

[Frank_E-W]

Your question might already have been answered here: 

Solved: Multiple TextBetween? - Qlik Community - 998974

[OmarBenSalem]

load Field where len(trim(Field))=3;
load purgechar(Subfield,'%') as Field where left(Subfield,1)='%' and right(Subfield,1)='%';
load replace(Field,'%%','%|%') as Field,
SubField(replace(Field,'%%','%|%'),'|') as Subfield Inline [
Field
"Enter the subject, choose a Board and ask away! You might just find a similar question that has been answered."

"%%ABC%% World is approaching! Take your data to the next level %%DEF%%and similar $$123$$"

"New solution %%IJH%% Timetable %%XYZ%%"
];

[rajinikanth]

Hi Omar, Thanks  a ton it worked out for me, can i get values like the below filed as output.

Field

ABC,DEF,IJH,XYZ

[OmarBenSalem · Accepted solution]

Sure

Just add this

load Concat(distinct Field,',') as Field;
load Field where len(trim(Field))=3;
load purgechar(Subfield,'%') as Field where left(Subfield,1)='%' and right(Subfield,1)='%';
load replace(Field,'%%','%|%') as Field,
SubField(replace(Field,'%%','%|%'),'|') as Subfield Inline [
Field
"Enter the subject, choose a Board and ask away! You might just find a similar question that has been answered."

"%%ABC%% World is approaching! Take your data to the next level %%DEF%%and similar $$123$$"

"New solution %%IJH%% Timetable %%XYZ%%"
];