Joins on a matching field( remove .0 after the decimal)

Question

HI All,

I'm trying to match two files based on certain matching conditions.

the matching field has values like ABC11.0 DEF11.3 and the other file has values like DEF11.3 and ABC11.

Is there a way I can just remove the .0 from 11.0 but keep the decimal for 11.3 as I still need 11.3 to match with 11.3 which works fine for now.

I can't round off here.let me know if there is a workaround here.

Thanks,

Rahul

fmvizcaino · Accepted Answer

Hi @rahulshetty925 ,

You thing you can do is to use a formula tool and use the replace function.

Replace([YourField], '.0', '') - it will identify every case of .0 and remove it.

Let me know if that works for you.

Best,

Fernando Vizcaino

BrandonB · Accepted Answer

You can say Replace([value], “.0”, “”) in order to remove the .0