Trim Field function - Extract number from text

[#1]

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

[#2 · Accepted solution]

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