How to split a text string into 3 parts in Crystal Reports

[bjez]

Hi, I'm working in Crystal Reports 8 (SQL 7 is my database)and need help writing a formula field. I have a field {evaluations.level_path} of type String that contains information about an employee's reporting structure. It looks just like this:
"Department Name\Department AVP\Manager Name"

I need to extract each of the three parts of the string using the "\" as my delimiter. I tried using a Split but I can't get it to work. Any ideas on how to write this formula in Crystal? Thanks! Barb

 

[synapsevampire]

Try each of the following for each part (the [X] is the subscript position of the string):

split("Department Name\Department AVP\Manager Name&quot[1]
split("Department Name\Department AVP\Manager Name&quot[2]
split("Department Name\Department AVP\Manager Name&quot[3]

Substitute your field after you understand how it works.

-k

 

[bjez]

Problem solved! Thanks for your help.

 

[bdreed35]

I think that you would actually want to tell it what the delimiter is otherwise " " is assumed.

split("Department Name\Department AVP\Manager Name", "\&quot[1]
split("Department Name\Department AVP\Manager Name", "\&quot[2]
split("Department Name\Department AVP\Manager Name", "\&quot[3]


~Brian