SUBSTR(TRIM in Qlikview

[#1]

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]

Please try this out.

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

thanks,

Rajesh Vaswani

[#3]

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

F

[anbu1984]

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