how to use expression If change and insert the text with num

[bsbernabe]

Hello There,

How can we change the text and insert a text including number Field value?

sample Datasource

Field

U123

123

=IF((left(text(Field,1) = 'U') then can change text to F in right like  123F , If(left(text(Field, 1), null)) then can insert R in righ like 123R?

I try so many expression but the result is not like this.

Field	Should be result
U123	123F
123	123R

Best Regards,

Bing

[tresesco · Accepted solution]

May be like:

IF((left(Field,1) = 'U'), '123F' , If( Istext(left(Field, 1)) , '123R')) as NewCol

[bsbernabe]

Thanks but this is not the right solution See the attached file result to from expression.

[tresesco]

Try :

IF((left(Field,1) = 'U'), mid(Field,2)&'F' , If( IsNUM(left(Field, 1)) , Field&'R')) as NewCol