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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Removing Lead Characters from a String 1

Status
Not open for further replies.
beth4530

beth4530

Technical User
Joined
May 5, 2011
Messages
44
Location
US
I have a field that has Sweetser_1\ preceding the employee name.
How do I trim these characters so I have just the employee name?
 
Sort by date Sort by votes
i think the below should give you everything after the first 11 characters. you may need to tweak it a little, as i do not have crystal in front of my and my memory is certainly not 100%!

//{@midtoend}
numbervar ltf := len({table.field});
MID({table.field},11,ltf)

 
Upvote 0 Downvote
Thank you!!! It worked
 
Upvote 0 Downvote
You could use:

mid({table.field},12)

-LB
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

D
  • Locked
  • Question Question
Running total from a subreport only showing last value
Replies
4
Views
1K
doodledump
D
LauraW
  • Locked
  • Question Question
Format Numbers in a String
Replies
4
Views
984
LauraW
LauraW
socalvelo
  • Locked
  • Question Question
Extract Phone Numbers from Text Field
Replies
0
Views
693
socalvelo
socalvelo
sofseattle
  • Locked
  • Question Question
Crystal formula for barcode display shows extra characters in date format?
Replies
1
Views
658
BobSuruncle
BobSuruncle
B
  • Locked
  • Question Question
Difference of a field between 2 variable dates
Replies
1
Views
611
hilfy
hilfy

Part and Inventory Search

Sponsor

Back
Top