extract number from the string

[Ekta]

Hello,

I have a scenario below wherein I need to extract the number from a string:

1,234.59 MR I MIMa  qwerty                                  output 1,234.59

1,234.59 MR                                                                       1,234.59

Could you help me with this scenario?

Thanks in advance.

[marcusblackhill]

Hey @Ekta !

A easy way to do that is using Data Cleansing tool, there you can select the column and mark the checkbox to remove letters.

Hope that helps

[echuong1 · Accepted solution]

You can use regex.

(.*\d)\s\w.+ will grab everything before a space following a digit. You can also use text to columns.

[marcusblackhill]

If you need help to configure:

1. Select the target field here

2. Check this box

If you need this in a different column, can duplicate the original column using formula tool and do that with the new one.

[Ekta]

Thanks a lot 🙂 works for me