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 SkipVought 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
0
0
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

Cpreston
  • Locked
  • Question
Remaining Text does not appear problem 2
Replies
10
Views
133
Cpreston
Cpreston
DMB62476
  • Locked
  • Question
SUPPRESS A TEXT BOX WHEN A REPORT FIELD MATCHES EITHER VALUE
Replies
1
Views
48
lbass
lbass
crytalbria
  • Locked
  • Question
Remove text between two points within a string
Replies
4
Views
76
crytalbria
crytalbria
jlr123
  • Locked
  • Question
Subtotal - row level by text field Cross Tab
Replies
4
Views
51
jlr123
jlr123
smmedeiros
  • Locked
  • Question
Removing or replacing IP address from text field 1
Replies
11
Views
111
smmedeiros
smmedeiros

Part and Inventory Search

Sponsor

Back
Top