Novice has question about parsing

[Philip Jenks]

Hello - I've got a field which has 5 lines of address in it, each line separated by a carriage return. e.g.

23 Cherry Tree Cottage

Lowdown Lane

Devizes

Wiltshire

SN3 4GH

I want to run a script which consecutively:

Copies Line 1 and pastes it into a separate Address 1 field

Copies Line 2 and pastes it into a separate Address 2 field

Copies Line 3 and pastes it into a separate Address 3 field

etc.

Trouble is, I don't know how to grab those individual lines in order to copy them. I have a vague idea that I should be setting up new calculation fields and use the 'Left' function, but don't know how to do it.

Grateful if an FPro genius could step forward and advise.

Thanks

[Vaughan]

Are you really using FMP 5?

[Philip Jenks]

Hi Vaughan, no I'm using 11. Oops. Better update my profile.

I've think I've solved the problem by using Set Field and then

GetValue(${Firms & Chambers}::Notes; 2)

There was a previous thread here which gave the answer. [Lesson: look first, ask afterwards!]

[Vaughan]

I was going to suggest the GetValue() function.

I also suggest NOT using illegal characters in field and relationship names. Get rid of the ampersand. It will cause problems later.