topic Re: Trim function in QlikView

Trim function

wossenhh — Mon, 12 May 2014 21:37:27 GMT

Hi,

Can anybody help me how to use trim function? The data looks like below:

Department
115 - AMC
220 - BMC
331 - LAN

And the intended results should be with out the numbers and -

AMC

BMC

LAN

Thanks,

Wossen

Re: Trim function

Mon, 12 May 2014 21:38:38 GMT

Is that always the format? if so, you can just use Right(Field,3) as FieldName

Re: Trim function

MarcoWedel — Mon, 12 May 2014 22:19:25 GMT

If there will always be a delimiter like '-' then you could use something like

=Trim(SubField(Department, '-',2))

regards

Marco

Re: Trim function

Clever_Anjos — Mon, 12 May 2014 23:42:11 GMT

PurgeChar(Department,'01234567890 -')

Re: Trim function

wossenhh — Tue, 13 May 2014 14:51:18 GMT

Thanks Marco! I can able to use the suggestion if I create table or chart. How about for a listbox?

Thanks,

Wossen

Re: Trim function

MarcoWedel — Tue, 13 May 2014 16:49:06 GMT

you can use this expression in a listbox also.

Just select "expression" instead of a field and copy/paste this expression.

regards

Marco

Re: Trim function

wossenhh — Tue, 13 May 2014 18:25:25 GMT

Hi Marco,

It didn't work. I get a result as

115 - AMC -

220 - BMC -

331 - LAN -

instead.

Wossen

Re: Re: Trim function

MarcoWedel — Tue, 13 May 2014 21:31:19 GMT

like this?

I also attached my qvw

hope it helps

regards

Marco

Re: Re: Trim function

wossenhh — Thu, 15 May 2014 14:15:46 GMT

Thanks so much Marco!

Re: Trim function

MarcoWedel — Thu, 15 May 2014 21:26:38 GMT

you're welcome.

please mark this thread as answered if you don't have any further questions.

thanks

regards

Marco

Re: Trim function

MarcoWedel — Thu, 15 May 2014 21:41:25 GMT

thanks, now it's answered indeed ...

... although the message you marked as correct does not contain the answer ...