splitting text from a textfield

[balooka]

Hi,

Is there a way to split up text from a textfield that has normal carriagereturns?

Example:

text now is (in one field):

Bananas

Yellow or green

grow on trees

I need those three lines in separate fields since i'm having trouble exporting files with those vertical tabs FM produces. The users of this solution import the exportfile directly into Quark Xpress and will get a huge amount of pages because those VT's create a new page for each occurence.

Or is there an easier way to export the above data? To clearify some more, the data shown above (banana's etc) reside in a lineitems DB and the main DB calculates the exportfield. Since CR's are not supported in the exports I need a solution to get the output as above. Troi seesm to have some plugins for that but im not sure if thats what im looking for.

Any thoughts?

TIA

JP

[Ugo DI LUCA]

Hi,

You could use a script or calculations for that.

c_return1stOccurence =MIDDLE(

yourtext,1,

POSITION(text, "

[balooka]

Hi Ugo!

Worked like a charm! Thank you very much!

Your reply was emailed to me by this forum and as I entered the calcs you provided it didnt work.... the carriage return was not in the mail resulting in a not working calc... but no wthat I'm here I see what I did wrong!

Thank you

JP

[Ugo DI LUCA]

Balooka,

I would just add something. I'm not sure you shouldn't turn the above calcs to plain text fields using a lookup (modkeys?) before any export/import.