Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Sept. 16, Qlik Product Portfolio Strategy and Roadmap for Data Integration 11 AM ET REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

SUBSTR(TRIM in Qlikview

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


3 Replies
rajeshvaswani77
Specialist III
Specialist III

Please try this out.

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

thanks,

Rajesh Vaswani

Not applicable
Author

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
Master III
Master III

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