Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

replacing text

Status
Not open for further replies.
mart10

mart10

MIS
Nov 2, 2007
394
GB
I am using CR 16

I sometimes have data with text at the end saying "- Group" eg "abcdefghijk - Group" or 12345 - Group" how do I remove the - Group and leave abcderghijk or 12345
 
Sort by date Sort by votes
Trim(Left({table.field},instr({table.field},”-“)-1)

Be sure to replace my quote marks with your own.

-LB
 
Upvote 0 Downvote
An alternate approach would be:

Code: 
Replace({Table.Field}, '- Group', '')

This would also avoid the problem that would arise if the text had another "-" in it, in addition to the one before "Group"

Cheers
Pete
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

socalvelo
  • Locked
  • Question
Extract Phone Numbers from Text Field
Replies
0
Views
170
socalvelo
socalvelo
Cpreston
  • Locked
  • Question
Remaining Text does not appear problem 2
Replies
10
Views
266
Cpreston
Cpreston
DMB62476
  • Locked
  • Question
SUPPRESS A TEXT BOX WHEN A REPORT FIELD MATCHES EITHER VALUE
Replies
1
Views
113
lbass
lbass
crytalbria
  • Locked
  • Question
Remove text between two points within a string
Replies
4
Views
113
crytalbria
crytalbria
jlr123
  • Locked
  • Question
Subtotal - row level by text field Cross Tab
Replies
4
Views
64
jlr123
jlr123

Part and Inventory Search

Sponsor

Back
Top