J. Williams Posted February 16, 2006 Share Posted February 16, 2006 Field data I already have: 03-1A3B5C7 Field data I need: 1A3B5C7 Is there a way to strip the "03-" from data that begins specifically with "03-" (some won't have an 03- or may have 03 with no dash as part of number, which I'd want to leave alone) to get the field data I need? Any shove in the right direction would be appreciated. JW Link to comment Share on other sites More sharing options...
Lee Smith Posted February 16, 2006 Share Posted February 16, 2006 (edited) If the pattern is always 03- and the field will not have a second 03- in it, the you can use this calculation in a field Substitute ( Your_Field, "03-", "") Lee Edited February 16, 2006 by Guest Link to comment Share on other sites More sharing options...
sbg2 Posted February 16, 2006 Share Posted February 16, 2006 If you might have another occurance of 03- then If(Left(Text;3) = "03-", Right(Text;Length(Text)-3),Text) Link to comment Share on other sites More sharing options...
J. Williams Posted February 17, 2006 Author Share Posted February 17, 2006 Thanks so much - I was able to use both (for different fields) with splendid results! Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6643 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now