Extract multiple values 1

[flmngldn]

I am working on Crystal 8.5.
database is Persive and excel file
I have a record of Purchase order that contains parts and its cost. There is referencce field containing the following:

735/736/737 ( This could be multiple numbers with "/" as deliminator)

Excel File)
70035 ( project#) 735(SN) 20 ( % of total cost)

What I am trying to do is to extract all the number between the "/". After the extract I would like to get the % value and multiply it by the cost in the PO. I have been successful extracting the first portion of it but not sure how I would go around getiing all the fields. I think I should have an arrya but have not figured out how to create arrays in Crystal.

 

[synapsevampire]

The following will create an array from the reference field:

split({table.reference},"/")

Now you might use a subreport for the Excel data and then join the data using this formula.

However I would look at creating an intelligent data source by using MS Access to link (not import) in the Persive (is that supposed to be pervasive?) and Excel data, and then create a query to normalize the data, and use additional queries to produce the proper dataset and use the Access query as the data source. It should prove faster and much easier to maintain.

-k

 

[flmngldn]

Thank you for the information. The database is pervasive. Sorry for the spelling error.
I tried this and I got the message "The result of a formula cannot be and array".
I am new at this and I know I am missing something but not sure what. I need help in writing this code.
Thanks