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 strongm 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
186
BobSuruncle
BobSuruncle
GCL2007
  • Locked
  • Question
Add leading ***** and a $ sign to check report 1
Replies
2
Views
69
GCL2007
GCL2007
tdrBates
  • Locked
  • Question
Strip last 3 characters from the field in the select case statement
Replies
3
Views
95
dgillz
dgillz
msi30502
  • Locked
  • Question
Filtering out pages 1
Replies
2
Views
68
msi30502
msi30502
JasonKaufman
  • Locked
  • Question
Pulling data out of a string
Replies
2
Views
70
JasonKaufman
JasonKaufman

Part and Inventory Search

Sponsor

Back
Top