This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
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...
