AnsweredAssumed Answered

Multiple spaces and returns

Question asked by cosmo on Aug 18, 2010
Latest reply on Aug 18, 2010 by philmodjunk


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.