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...
Some small improvements for edge cases:
Using LOWER() in each REGEX_EXTRACT() in case capitals exist already elsewhere in the emailAccounting for emails with hyphens/dashes (e.g. susie-jo.adams@gmail…)
IF(NOT(FIND('-',Email)),UPPER(LEFT(Email, 1)) & ...
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...
