Nam Posted February 6, 2008 Share Posted February 6, 2008 Hi there, We have project numbers in our database that are in the following format: xx-xxx-xx-xxx We are changing our project numbers now to be in this format: xxx-xx-xxxx How would I truncate the first two digits and the dash? Thanks in advance, Nam Quote Link to comment Share on other sites More sharing options...
AHunter3 Posted February 6, 2008 Share Posted February 6, 2008 Middle (CurrentProjectNumber, Position(CurrentProjectNumber, "-", 1, 1)+1, Length(CurrentProjectNumber)) Quote Link to comment Share on other sites More sharing options...
David Head Posted February 7, 2008 Share Posted February 7, 2008 Or more simply: Right (CurrentProjectNumber, Length(CurrentProjectNumber) - 3) smiley-smile Use in a calculated replace of the field contents. smiley-surprised Make sure you backup first. Quote Link to comment Share on other sites More sharing options...
By Soliant Consulting,
By Soliant Consulting,
By Soliant Consulting,
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.