Hi,

I would like to be able to split a field into two fields.

This field contains text see below:

Bridge House¶63-65 North Wharf Road

I would like to split this from the pilcrow. Important note to consider the pilcrow is literal. I have tried to use rightword in a calculation field but as the number of words vary from record to record I can't get a clean result.I'm not able to see a good text function that fits my needs. Any ideas?

Thanks

I just did a find on the pilcrow ("¶")and replaced it with a semi colon.

I then exported that field into excel and used the semi colon as a delimiter. I was then able to split the fields.I just imported the two fields back into Filemaker. Problem solved.

I would still like to find a solution using Filemaker. I know there must be a better way of doing this.

Thanks,

To break out the field contents within FileMaker, you can use a calc expression along the lines of:

Left(YourField; Position(YourField; "¶"; 1; 1) - 1)

...to retrieve everything that comes before the pilcrow, and use:

Right(YourField; Length(YourField) - Position(YourField; "¶"; 1; 1))

...to retrieve everything that comes after the pilcrow. :wink2:

That's excellent thanks.