[Webinar] Streamline your web hosting managementRegister Today


Formula to remove text after a colon in a string field

Posted on 2008-01-30
Medium Priority
Last Modified: 2012-06-22
I need to search a string field for a colon ( : ) and remove the colon and any text to the right of the colon.
In other words, I want to only display the text to the left of the colon.

Any ideas?

Thanks in advance


Question by:SStroz
  • 2
LVL 77

Expert Comment

ID: 20775831
Create a formula field:
LVL 77

Accepted Solution

peter57r earned 2000 total points
ID: 20775844
Sorry - forgot the array base for a moment there.

should be...

LVL 16

Expert Comment

ID: 20776902
a formula will work on this. This will find the first colon and then only return what is to the left of it.


Featured Post

2018 Annual Membership Survey

Here at Experts Exchange, we strive to give members the best experience. Help us improve the site by taking this survey today! (Bonus: Be entered to win a great tech prize for participating!)

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…
Kernel Data Recovery is a renowned Data Recovery solution provider which offers wide range of softwares for both enterprise and home users with its cost-effective solutions. Let's have a quick overview of the journey and data recovery tools range he…
Suggested Courses

613 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question