Multiple spaces and returns
Good Afternoon -
I have an unusual request - I have an excel sheet that I need to upload into Filemaker. Not that this is a problem, but instead of using soft returns within the cell - multiple spaces were entered until they were on the next line within the field.
My problem is that I need to replace the spaces with a (one) paragraph code <p>
To provide some visual, the number of spaces entered varies and if you exend the column width - the text from the previous lines move up along with the spaces.
Note: I am working on a mac using Filemaker Pro 10.
Thank you in advance for your suggestions.