Help

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

Topic Labels: Formulas
Solved
Jump to Solution
679 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Jason_Sheldon
4 - Data Explorer
4 - Data Explorer

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!

1 Solution

Accepted Solutions
ScottWorld
18 - Pluto
18 - Pluto

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:

See Solution in Thread

2 Replies 2
ScottWorld
18 - Pluto
18 - Pluto

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!