whew, this won’t be pretty… :thinking: I think the way to think about this is to ‘split’ the input into two parts; and then ‘extract’ the dollar/number you want out of it. so with your column named ‘input’, create a field named ‘dollarAmount’ with ...

Taking a brief look at your shared Table, maybe it is worth examining your first field… If you can get away with having the ‘Code’ be your Primary Key/Field then you have some quick Airtable tricks available to you to simulate a Index/Match. With ‘Co...

These are excellent examples and I too use those streamlined versions. Ok, I’m sold, onward!

Because you mentioned scraping… Here is another Formula that might come in handy: REGEX_REPLACE(TRIM({example of scraped text}), '\\s','.') So this does two important things: It trims or removes the whitespace that might be dragged along from the sc...