simple 4 line text parsing help please

[hartmut]

Hi

I have a paragraph with 4 lines.

Like

apples oranges bananas

Red orange yellow

round, round, oblong,

Fruit, citrus, Fruit

I need to send each Line into a field

like "firstline" "secondline" thirdline" fourth line"

Could I get some help with this

Thanks

[LaRetta]

One way (if you mean pulling the lines into different fields, would be to use GetValue(). For retrieving the first line: [color:blue]GetValue ( yourTable::yourText ; 1 ). For retrieving the second line: [color:blue]GetValue ( yourTable::yourText ; 2 ) ... and so on.

If you mean changing the multilines into ONE line within ONE field:[color:blue] Substitute ( yourTable::yourText ; ¶ ; ", " )

Update: Your example has commas in some instances but not others. Since I add commas, you will get doubles and it looks quite messy. You can clean it up by:

[color:blue]Substitute ( Substitute ( yourTable::yourText ; ¶ ; ", " ) ; ",," ; "," )

... but then, you DON'T have commas in other places. Without a clear pattern, I can't give a specific calculation so you may need to adjust as needed. :wink2:

Edited December 15, 2007 by Guest

[hartmut]

Thanks LaRetta