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

[rahulshetty925]

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 solution]

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 solution]

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

[rahulshetty925]

Hi All,

The below techniques work for the request but it throws off a number like 1.07 too.

My goal is to only exclude 123.0 (remove.0) in this case only if its towards the end.

Let me know if there is technique to do this.

Thanks,

Rahul

[fmvizcaino]

Hi @rahulshetty925 ,

Take a look in the attached example showing how to control that with Regex.

Best,

Fernando Vizcaino