Skip to main content
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
rajinikanth
Contributor III
Contributor III

Text between characters

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

 

Labels (4)
1 Solution

Accepted Solutions
rajinikanth
Contributor III
Contributor III
Author

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

View solution in original post

4 Replies
vchuprina
Specialist
Specialist

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:

vchuprina_0-1650541686979.png

Regards,

Vitalii

Press LIKE if the given solution helps to solve the problem.
If it's possible please mark correct answers as "solutions" (you can mark up to 3 "solutions").
rajinikanth
Contributor III
Contributor III
Author

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

vchuprina
Specialist
Specialist

Hi,

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

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

Regards,

Vitalii

Press LIKE if the given solution helps to solve the problem.
If it's possible please mark correct answers as "solutions" (you can mark up to 3 "solutions").