Discussion Board for collaboration related to QlikView App Development.
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 try this out.
Mid(TRIM("Order Number"), len(ltrim(rtrim("Order Number"))) - 9 + 1, 9) AS LOT_NUM
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)