AnsweredAssumed Answered

Imported data to Portal Question

Question asked by CarlSowden on May 12, 2011
Latest reply on May 12, 2011 by aammondd

Title

Imported data to Portal Question

Post

Hello there,

I'm doing ODBC imports from one database to File maker.

I have one field importing from the 'other' database that contains several lines of important data (in the one text field),

I.E

FIELD=

3000 X (UNIQUE_ITEM_CODE) (ITEM_DESCRIPTION)

3000 X (UNIQUE_ITEM_CODE2) (ITEM_DESCRIPTION2)

3000 X (UNIQUE_ITEM_CODE3) (ITEM_DESCRIPTION3)

and so on.....

This field is imported via a match field called JOB_NUMBER

What i want to do is to be able to seperate these lines and put them into a portal as individual records all relating back to the JOB_NUMBER field.

I there a way I could convert this text field containing (let's say 3) lines of data into a Portal that would beable to display these 3 lines of data as individual records?

Any help would be amazing!

Carl.

Outcomes