Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Trim Field function - Extract number from text

hi i am recieving the field name as the following example:1234

what i would like to do is extract only the number from the field  as 1234.

how do i use the trim function in Qlikview to give me the last four spaces from the right hand side only?

Best,

Bradley

1 Solution

Accepted Solutions
Not applicable

Re: Trim Field function - Extract number from text

right(name,len(right(name,4) )) as name

1 Reply
Not applicable

Re: Trim Field function - Extract number from text

right(name,len(right(name,4) )) as name

Community Browser