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?
right(name,len(right(name,4) )) as name
Retrieving data ...