Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
abhaytrip
Creator
Creator

Remove extra characters.

Hi all,

I've got a situation where i would like to remove ' AB- ' & '???' below characters from table.

i would just like to have QWE  , DFG , WER , RTY, TYU,GHJ in my field and nothing else in it.

is there a way i can achive this ?

 

AB-QWE
AB-DFG???
AB-WER???
AB-RTY ???
AB-TYU ???

AB-GHJ???

1 Solution

Accepted Solutions
atoz1158
Creator II
Creator II

Hi

If the strings are always if that format then try the following

PurgeChar(Mid(Yourfield,4),'?')

Regards

Adrain

View solution in original post

5 Replies
sergio0592
Specialist III
Specialist III

Hi,

Try with : left(subfield(YourField,'-',2),3)

StarinieriG
Partner - Specialist
Partner - Specialist

Hi

try with this

Subfield(PurgeChar(FIELD,'?'),'-',2)

atoz1158
Creator II
Creator II

Hi

If the strings are always if that format then try the following

PurgeChar(Mid(Yourfield,4),'?')

Regards

Adrain

Brett_Bleess
Former Employee
Former Employee

Abhay, did any of the posts get you what you needed to resolve things?  If so, please be sure to circle back and use the Accept as Solution button on those that did get you want you wanted.  If you ended up doing something different, please consider posting that for others, and you can then mark it as the solution as well.  If you are still trying to figure things out, please leave an update for us.

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.
abhaytrip
Creator
Creator
Author

thanks alot mate. This helped me , sorry for late acceptance as my id wouldn't work.