EASY Replace (I think)

Platform discussions
1

How can I convert this;
The customer @ an evening conversation #happy mentioned!!! He might be…… willing (I think) to pay $6,475 for the project.

And convert it to
6475 (integer)

Basically, delete all letters and special character and see what’s left.

2

@SpinningMyHead

Not elegant. But it will work (as long as the digits are not broken into more that 5 segments:

0 + "0" & REGEXREPLACE(REGEXREPLACE(REGEXREPLACE(REGEXREPLACE(
REGEXREPLACE({text }, "[^0123456789]*", ""),
"([0123456789]*)[^0123456789]*","$1"), "([0123456789]*)[^0123456789]*","$1"),
"([0123456789]*)[^0123456789]*","$1"), "([0123456789]*)[^0123456789]*","$1")

Jim - The Monday Man
Get Custom Apps, Integrations & Automations for monday

3

Thankful for your help. I may need to manage my expectations of this platform. I am developing ideas and expecting to calculate the square root of Pi divided by X. While in fact the platform is limited to 1 + 1. A bit of a disappointment.