[Peter Gulka]

I'm in a tough spot. I have 4 pieces of data that I need to track on a gift record. I had been doing it in 2 attributes, but recent events have rendered that solution impossible.

I need to track some information on specific scholarships that theese gifts are funding. The attributes were tracking:

- quanity of the award
- award name
- award description
- award amount

I need to do this in one place so that when multiple awards are used the order of the attributes does not affect the report generation.

Once idea was using '3@1500' to represent the number of awards and their value. I would then need to parse out the 3 and 1500 seperately in formulas so I could use them as distinct values.

Any ideas?

[Peter Gulka]

hmm... this seems to work. I think...

//assuming a format of 2@1500
// - 2 awards
// - $1500 each
 
//gets the number of awards
left({attribute_field},instr({attribute_field},"@")-1)
 
//gets the award amount
right({attribute_field},(Length ({attribute_field})-instr({attribute_field},"@")))

[DrewAllen]

That will probably work, but it's easier to use the Crystal Split function which has four variants. So in your case you could use Split({attribute_field}, "@"). Split returns an array of the substrings.

Drew

[Peter Gulka]

hmmm... but my formula can't return an array, so what do I do with it then?

[DrewAllen]

You just pull whichever pieces you need out of the array and return those. You may need multiple formulas if you need to return the pieces separately.

Drew