i'm new to this forum and still somewhat a beginner with crystal.  the issue that i am stuck on is a token string.  Here's what it looks like out of the database:

16    702
18    US TREASURY 310 SOC SEC   120310

I understand (I think) that the 16 and 18 are the numeric identifiers, but what i want to actually print on the report is the the wording US Treasury 310 Soc Sec.

Is there a way I can go about that in crystal? A formula?  Formula's are not my strong suit (yet).
I appreciate any feedback and assistance as this is my first post. :)

no the wording can vary. i'm hoping to get the wording for each individual line.  i'm working on direct deposits and wanted to capture who/where the deposit is coming from.


Edited by stilllearning - 17 Mar 2011 at 9:00am

here are some other strings:

16    701
18    US TREASURY 312 CIVIL SERV010311
(would want US Treasury 312 Civil Serv)



16    501
18    RAYTHEON        PAYMENT   110101
(would want Raytheon Payment)

16    900
18    IN HOME HEALTH CPAYROLL        
(would want In Home Health CPayroll)