Multiple Subtitue

[Clyteroll_Cabua]

Multiple Substitute in Airtable, I have one field that contains jebirish information but it contains one of the information. like ’

Field updated

UNDO

Your Account Name:		Reillence Lester Diocson
Your Account Number:		9189160337
Your Pin Number:		860503

I want to make a formula get the Account Number only not the Jiberish character. How should I do this?

[Kamille_Parks]

Clyteroll_Cabual:

I have one field that contains jebirish

For your reference, this isn’t gibberish its HTML. Is there a particular reason why your data includes a whole table in HTML format instead of just the individual data points (name, number, pin)? Where is the data coming from and is it possible to adjust your import method to come out cleaner?

Since you didn’t include the full output of the field the answer may vary depending on the following:

• Is the account number always the same number of characters?
• Is the account number always preceded by (presumably, guessing based on standard HTML structure) this?:
  <td>Your Account Number:</td><td>

[Justin_Barrett]

Not long ago I shared a solution that extracts HTML tags from text.

Google Calendar Sync generates HTML in the "Description" field Airtable Sync

Welcome to the community, @Madara_Mason! :smiley: I recommend making a formula field and using this to create a clean version of the data: TRIM(REGEX_REPLACE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(Description, "&amp;", "&"), "&nbsp;", ""), "</p>", "\n\n"), "<br>", "\n"), "<[^>]*>", "")) That formula directly replaces certain tags with equivalent symbols (newlines, ampersands, etc.), and then REGEX_REPLACE() bulk-replaces any other HTML tags with nothing, followed by a final trim to clean …

With a tweak, you could also use this to remove the “Your Account Number:” prefix.