How to pull specific info from a string field? CR8.5

[Digitalcandy]

I have a string field that is 25 characters maximum. This field has two items in it that I want to be able to seperate from each other. Examples are as follows;

1.06;5.98
10.45;20.55
.45;.89

Above I've shown 3 string examples of what the field could possibly look like. As you can see there are 2 data items seperated by a semicolon. The first item represents a price and the second represents a quantity. How can I seperate the two being that the two items are not always the same length but are always seperated by a semicolon?

TIA.

 

[IdoMillet]

Have a look at the Split() function.

Cheers,
- Ido

CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[Digitalcandy]

A little more clarity on the split() function would be very helpful.

Thanks.

 

[synapsevampire]

Try:

whileprintingrecords;
strvar array MyValues := split({Table.Field},";&quot

Now you can reference them later using:

whileprintingrecords;
strvar array MyValues;

MyValues[1] and MyValues[2]

-k

 

[Digitalcandy]

synapsevampire, thanks for the help but I'm not following your example.

I made a formula, {@Array} and the code is the following;

whileprintingrecords;
strvar array MyValues := split({Table.Field},";&quot


But it will not allow me to save it because it says, "The result of a formula cannot be an array".

I did not even try the "referencing" part you mentioned as I could not even figure out what is going on with the first part of your example.

BTW, I assumingly changed "strvar" to stringvar.

 

[dgillz]

heres an example:

WhileprintingRecords;
Stringvar array Dons:=split("eron;lsdkfj;slkjf;",";"
dons[2];

This formula returns "lsdkfj"


Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com

 

[Digitalcandy]

Perfect! I understand now. Thanks.