I think what you want is something like:
split({Remedy field},"|")[1]
Remedy field is replaced with whatever db field you're reporting against,
the delimiter you're using encapsulated with quotes followed by the array
subscript which in Crystal syntax I believe starts at 1. Hope that helps.
I've found this website VERY helpful when I'm having Crystal questions:
http://www.tek-tips.com/
The home page is busy, but if you use the search option and put crystal in
you'll get to the main forum for crystal.
Shawn Stonequist <[EMAIL PROTECTED]>
Sent by: "Action Request System discussion list(ARSList)"
<[email protected]>
04/18/2007 10:52 AM
Please respond to
[email protected]
To
[email protected]
cc
Subject
Crystal Question: Arrays
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"
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the
Answers Are"
