SStroz
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
In other words, I want to only display the text to the left of the colon.
Any ideas?
Thanks in advance
Steve
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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(col umnname,': ')-1)
Mid(columnname,1,instr(col
Split({table.Field},":")[0