Skip to main content

Multiple Subtitue

  • October 5, 2021
  • 2 replies
  • 22 views
C
Forum|alt.badge.img+1

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?

2 replies

Kamille_Parks11
Forum|alt.badge.img+27

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
Forum|alt.badge.img+21
  • Justin_Barrett
  • Inspiring
  • 4647 replies
  • October 10, 2021

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.


Terms & ConditionsAccessibility statement