Link to home
Start Free TrialLog in
Avatar of SStroz
SStrozFlag for United States of America

asked on

Formula to remove text after a colon in a string field

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

Steve

Avatar of peter57r
peter57r
Flag of United Kingdom of Great Britain and Northern Ireland image

Create a formula field:
Split({table.Field},":")[0]
ASKER CERTIFIED SOLUTION
Avatar of peter57r
peter57r
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
a formula will work on this. This will find the first colon and then only return what is to the left of it.

Mid(columnname,1,instr(columnname,':')-1)