Skip to main content
Solved

Remove 'the' from only the start of a field?

  • August 13, 2020
  • 2 replies
  • 25 views
J

Hi, Sorry if this seems a simple issue, but I’ve got a table with a list of venues… some start with “the” (eg: The Royal Albert Hall).

I want to be able to display the list of venues in proper name order - ie: Royal Albert Hall, without “the”…

I’m thinking having the full name as one field, and a second, formula, field which removes THE if it’s the first word, but not if it’s in the middle of the name - eg: Her Majesty’s THEatre, or Auditorium at THE Excel Centre…

Could anyone help please? Thanks!

Best answer by ScottWorld

Yes, I would create a second formula field.

It could look something like this:

IF(Left({Venue Name},4)="The ",Replace({Venue Name}, 1, 4, ""),{Venue Name})

Hope this helps! If this answers your question, could you please mark this comment as the solution to your question? This will help other people who have a similar question. :slightly_smiling_face:

2 replies

ScottWorld
Forum|alt.badge.img+35
  • ScottWorld
  • Genius
  • Answer
  • August 13, 2020

Yes, I would create a second formula field.

It could look something like this:

IF(Left({Venue Name},4)="The ",Replace({Venue Name}, 1, 4, ""),{Venue Name})

Hope this helps! If this answers your question, could you please mark this comment as the solution to your question? This will help other people who have a similar question. :slightly_smiling_face:

J
Justin_Barrett
J
  • Jason_Sheldon
  • Author
  • New Participant
  • August 13, 2020

Yes, I would create a second formula field.

It could look something like this:

IF(Left({Venue Name},4)="The ",Replace({Venue Name}, 1, 4, ""),{Venue Name})

Hope this helps! If this answers your question, could you please mark this comment as the solution to your question? This will help other people who have a similar question. :slightly_smiling_face:


Perfect - thank you!

ScottWorld
Terms & ConditionsAccessibility statement