Hello all!
I am a beginning Crystal user and am having trouble creating a formula to do the following:
* I have a string field ({Rep}), that contains a user ID number and their name. The ID number is always constant, but may contain a different beginning variable. This will be either a "#" or a "E". For example #123456 or E123456.
* The {Rep} field itself looks like this in the database, for example:
#123456 J. Smith
E123456 B. Jones
#222222 James Bond
E654321 George Washington
So, the field is "User ID, 5 spaces, Name".
* What I am attempting to accomplish in the report is to somehow remove the # or E User ID and the 5 spaces completely, leaving only the name. For example:
J. Smith
B. Jones
James Bond
George Washington
Any help would be most appreciated and I thank you in advance!
I am a beginning Crystal user and am having trouble creating a formula to do the following:
* I have a string field ({Rep}), that contains a user ID number and their name. The ID number is always constant, but may contain a different beginning variable. This will be either a "#" or a "E". For example #123456 or E123456.
* The {Rep} field itself looks like this in the database, for example:
#123456 J. Smith
E123456 B. Jones
#222222 James Bond
E654321 George Washington
So, the field is "User ID, 5 spaces, Name".
* What I am attempting to accomplish in the report is to somehow remove the # or E User ID and the 5 spaces completely, leaving only the name. For example:
J. Smith
B. Jones
James Bond
George Washington
Any help would be most appreciated and I thank you in advance!