Greetings List! I'm trying to run a Crystal Report using Data from Remedy. In one field I have a menu which sets values such as
Value1: SubValue1 Value1: SubValue2 Value2: SubValue1 etc. I'm trying use the Split command to break these apart so I can group the SubValues by the Value in a Cross-Tab. I've got the formula for the Split, but I can't figure out how to use this to grab the first element created and display it so that I can use it in the groupings. Is there a way to do this? Or, is there another way to break this one field into two (e.g. like Excel's Text to Columns using a Delimiter of ":")? I've poured through the Crystal Help, but it wasn't helpful- when I seemed to get a valid solution, I was told that I needed to script the array, example: Array [i]. When I put the Split into the brackets, it said that the rest wasn't part of the equation. Thanks in advance for your help!!! Shawn Stonequist Emns, Inc. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
