topic Re: Remove extra characters. in QlikView

Remove extra characters.

abhaytrip — Sat, 16 Nov 2024 02:31:18 GMT

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???

Re: Remove extra characters.

sergio0592 — Tue, 10 Sep 2019 12:57:20 GMT

Hi,

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

Re: Remove extra characters.

StarinieriG — Tue, 10 Sep 2019 13:03:04 GMT

try with this

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

Re: Remove extra characters.

atoz1158 — Tue, 10 Sep 2019 13:13:52 GMT

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

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

Regards

Adrain

Re: Remove extra characters.

Brett_Bleess — Mon, 23 Sep 2019 16:17:31 GMT

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

Re: Remove extra characters.

abhaytrip — Tue, 24 Sep 2019 08:02:02 GMT

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