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

Are you really using FMP 5?

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!]

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.