Remove space and Decimal

EvansM

Hello everybody,

I need a help on couple of things.

1) I have got a number like this 662 8702125 and I want it to look like this 6628702125

2) I have got another number like 6627466074.000000 and I want it to look like this 6627466074

I did some research, and I found out I can achieve this by using RegEX. The problem I am not very good using RegEX.

I will appreciate any help.

Thanks

Custom Tools

Data Investigation

Accepted answers

neilgallen

Alternatively, using

tonumber(replacechar([Field1]," ",""))

in a formula tool would get the desired results, and not require the creation of any additional fields. Please note that this still would keep your current field formatted as a string and any field conversions would be required if necessary.

afv2688

Hello @EvansM,

You can indeed use the Regex tools for that, the only problem (in this case) it that you will loos al decimals:

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Regards

regex_number.yxmd

All comments

fmvizcaino

Hi @EvansM ,

Attached is an easier way to achieve that. You need to use only a formula tool and 2 functions.

Let me know if that works for you.

Best,

Fernando Vizcaino

2020-01-30 Remove space and Decimal.yxmd

neilgallen

Alternatively, using

tonumber(replacechar([Field1]," ",""))

afv2688

Hello @EvansM,

You can indeed use the Regex tools for that, the only problem (in this case) it that you will loos al decimals:

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Regards

regex_number.yxmd

EvansM

@neilgallen Thanks a lot

EvansM

@fmvizcaino Thanks a lot

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703