Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Multiple Subtitue

Topic Labels: Formulas
319 2
cancel
Showing results for 
Search instead for 
Did you mean: 

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?Screen Shot 2021-10-05 at 12.04.40 PM

2 Replies 2

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>

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

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