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

Number Masking

Status
Not open for further replies.
Drus

Drus

Technical User
Jan 29, 2002
43
US
I have a field of information that prints onto a form, and I need to mask it so that the first three characters do not appear, but only the remainder of it. How to?

Thanks,

Andrew Hagenbach
OPUS SYSTEMS, INC.
Andrew Hagenbach
OPUS SYSTEMS, INC.
916.503.3173
ahagenbach@opus-sys.com
 
Sort by date Sort by votes
Mid({FieldName},4) will return the entire string starting with character #4. Software Support for Macola, Crystal Reports and Goldmine
dgilsdorf@mchsi.com
 
Upvote 0 Downvote
You are awesome... Thanks! Andrew Hagenbach
OPUS SYSTEMS, INC.
916.503.3173
ahagenbach@opus-sys.com
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

socalvelo
  • Locked
  • Question
Extract Phone Numbers from Text Field
Replies
0
Views
229
socalvelo
socalvelo
socalvelo
  • Locked
  • Question
Limiting the number of records in groups and sub-reports 1
Replies
2
Views
151
socalvelo
socalvelo
Brian S
  • Locked
  • Question
Splitting names that have variable numbers of spaces 1
Replies
5
Views
312
Brian S
Brian S
Tichaona
  • Locked
  • Question
Row numbering formula not working
Replies
4
Views
297
lbass
lbass
LauraW
  • Locked
  • Question
Format Numbers in a String
Replies
4
Views
396
LauraW
LauraW

Part and Inventory Search

Sponsor

Back
Top