I need to change the data formats for the following
a. 123- needs to be changed to -123
b. All fields for a record with 00000 needs to be blank
Thanks in advance.
¡Resuelto! Ir a solución.
How about:
IF [_Current Field_] == "0000" THEN '' ELSEIF
RIGHT([_Current Field_] ,1) == "-" THEN "-"+ Trim_right([_current field_],"-")
ELSE [_Current Field_]
ENDIF
something like that should work and you can use it in a multi-field formual with a little change here or there.
BTW, '' is empty and NULL() is null
Cheers,
Mark
Hi @Abhii2658 -
This is a great use case for the Formula tool or Multi-Field Formula. Something like this should work for you.
IF Right([Field],1)="-" THEN "-"+Left([Field],Length([Field])-1)
ELSEIF [Field]="00000" THEN ""
ELSE [Field]
END