Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
May be like:
IF((left(Field,1) = 'U'), '123F' , If( Istext(left(Field, 1)) , '123R')) as NewCol
May be like:
IF((left(Field,1) = 'U'), '123F' , If( Istext(left(Field, 1)) , '123R')) as NewCol
Thanks but this is not the right solution See the attached file result to from expression.
Try :
IF((left(Field,1) = 'U'), mid(Field,2)&'F' , If( IsNUM(left(Field, 1)) , Field&'R')) as NewCol