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!

strip out leading characters

Status
Not open for further replies.
mart10

mart10

MIS
Nov 2, 2007
394
GB
I am using CR2016

How can I consistently strip out the first leading 5 characters (including a space) of a variable length field as below:

Original Required

BNPP DVPGBR GBP COL --> DVPGBR GBP COL
BNP DVPGBR GBP --> DVPGBR GBP

 
Sort by date Sort by votes
thanks, actually I sorted it with same simple idea
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

sofseattle
  • Locked
  • Question
Crystal formula for barcode display shows extra characters in date format?
Replies
1
Views
197
BobSuruncle
BobSuruncle
GCL2007
  • Locked
  • Question
Add leading ***** and a $ sign to check report 1
Replies
2
Views
80
GCL2007
GCL2007
tdrBates
  • Locked
  • Question
Strip last 3 characters from the field in the select case statement
Replies
3
Views
97
dgillz
dgillz
msi30502
  • Locked
  • Question
Filtering out pages 1
Replies
2
Views
71
msi30502
msi30502
JasonKaufman
  • Locked
  • Question
Pulling data out of a string
Replies
2
Views
74
JasonKaufman
JasonKaufman

Part and Inventory Search

Sponsor

Back
Top