Extract text from portal to simple text field

Hi there!

I'm working on a very extended catalogue(about 700 pages).

This catalogue is being designed in quarkXpress.

It is about music cds and dvds.

In its final form(in a quark page) there should be appearing these items:

Artist name

Title

Barcode

Catalogue number

Price range

and of course the tracks.

The tracks should be appearing in a specific form:

Mister Sandman / The Poor People Of Paris (Jean's Song) / Boo Boo Stick Beat / Alley Cat / Travelin' / Yakety Axe / Yesterday / Blue Angel / Theme From "Zorba The Greek" / Snowbird / Steeplechase Lane / Jerry's Breakdown / Black Mountain Rag / Fiddlin' Around / Somewhere My Love (Lara's Theme From The Film "Doctor Zhivago")

One way I followed to gain information is via a small program called "delicious library".

This program can search for a cd in the web, even if you only insert its barcode number.

Since I already had the barcode numbers from the database of the music company, it was quite easy for me to gain information(mainly about the tracks) for about 5000 cds!

"Delicious Library" can export its library contents into text tab delimited format.

You can see an example in the .xls file attached.

In my database in filemaker the songs are in their own table, and of course every track has its own record number.

(Recently a very kind forum user helped me with a script, that took a text with slashes and splitted it into seperate records.)

There are several cds that their tracks are in record format and not text with slashes.

So I had to find a way to extract the text from the portal into a single field.

I wrote a little script that I would like to share with you.

It has a small error(it puts a slash after the last song, and we don't want this to happen), but it works fine.

George Toubalis.

text_to_portal_to_text.fp7.zip

Black_delicious_lib.xls.zip

Edited May 2, 200718 yr by Guest