topic Re: SUBSTR(TRIM in Qlikview in QlikView

SUBSTR(TRIM in Qlikview

Tue, 30 Dec 2014 09:09:19 GMT

Hi,

I have to trim the field in qlikview .I'm getting the result using the below expression in DB.

SUBSTR(TRIM("Order Number"), CHAR_LENGTH(TRIM("Order Number")) - 9 + 1, 9) AS LOT_NUM

I tried using MID/LEFT/RIGHT. Seems like i'm missing out something.

Please suggest.

Thanks

rajeshvaswani77 — Tue, 30 Dec 2014 09:12:54 GMT

Please try this out.

Mid(TRIM("Order Number"), len(ltrim(rtrim("Order Number"))) - 9 + 1, 9) AS LOT_NUM

thanks,

Rajesh Vaswani

Tue, 30 Dec 2014 09:13:58 GMT

Not sure what you mean but with TRIM you strip off all the spaces from the string that are in the beginning and end of your string so:

trim([Order Number]) as Your_Field, you can eventually enhance it with other string commands (see help for list of commands)

cheers

anbu1984 — Tue, 30 Dec 2014 09:19:37 GMT

Right(Trim("Order Number"),9)