Translating Coded Result toa # 1

[mjm19]

Hi,

Using CR8.
I have a coded result that comes over in a result field that
needs to be converted to the same number everytime. In other words the code ABCDEFG is the result that I need to convert to 123456.
This must be pretty simple to do, but escapes me.

Thanks

 

[lbass]

Try:

if {table.code} = "ABCDEFG" then "123456" else {table.code}

-LB

 

[lbass]

If you want to convert it to a number datatype, then try something like:

if {table.code} = "ABCDEFG" then 123456 else
if isnumeric({table.code}) then tonumber({table.code}) else
0

-LB

 

[mjm19]

-LB ... thanks very much. One more thing ...
So it does change every ABCDEFG to 123456. How doI suppress
the ABCDEFG code ?

 

[lbass]

I'm not sure what you're asking. You would use a formula like the above in place of your {table.code} field, so you need to be clear on what you want to happen to other results of the {table.code} field. In my last formula, if the result is <> "ABCDEF", but is numeric, the code field will be displayed as a number. If it is non-numeric (and <> "ABCDEF"), it will display as "0".

-LB