How do I return one value of arrray?

[Former Member]

I am writing a report that includes a field which contains several numeric variables that are separated by a delimiter ';'. An example of the contents of this field is 4930;3988;0;0;0

I only need the first value associated with this field but I can't figure out how to capture just this one value. I have researched Crystal's Help file and thought that the 'split' function might give me the results I need but I have either misinterpreted the function or am looking at the wrong function for help.

Has anyone run accross a field like this and know what I can do to grab the single value that I need?

Thanks so much for any help you can provide.

Marlene Allen

Crystal Reports Developer

Crystal Report 2008

Version 12.3.0.601

Edited by: Marlene Human on Jun 9, 2011 11:55 AM

[JWiseman · Accepted solution]

hi Marlene,

use a formula similar to

split({fieldvalue}, ';')[1]

jamie