Thanks Harvey - that gave me an idea and I successfully used the substitute function within FileMaker Substitute ( Field ; "¬" ; ¶ ) to restore the returns. The ultimate destination is a LastPass vault but I'll need more time to see what that accepts so I'll see how I go in that arena before I post here again.
On Saturday, September 25, 2021 at 6:07:17 AM UTC+10 Harvey Pikelberger wrote: > Hi Russell, > > Does your workflow involve round trips between Excel and FileMaker or > between FMP/Excel and *other* applications? > > Excel & FMP play nice with each. Line feeds in either one will > import/export to the other with no strange characters. > > FMP has an arsenal of tools that pretty much guarantees you can export to > just about software of any kind, handling any and all character encoding / > translation issues. You could even extend that to importing from Excel to > FMP then exporting to the 3rd part app. > > On Sep 23, 2021, at 12:33 AM, Russell B <[email protected]> wrote: > > > I often convert database content moving from one type of database to the > other. I always hit an issue with the soft returns in data within fields, > where line breaks were entered in the application - they convert into weird > characters when exported to text. Is there any way of cleaning these up in > BBEdit without interfering with the hard returns that delineate a new > record? I usually work in Excel or Filemaker pro. > > -- > This is the BBEdit Talk public discussion group. If you have a feature > request or need technical support, please email "[email protected]" > rather than posting here. Follow @bbedit on Twitter: < > https://twitter.com/bbedit> > --- > You received this message because you are subscribed to the Google Groups > "BBEdit Talk" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To view this discussion on the web visit > https://groups.google.com/d/msgid/bbedit/c2a16db0-85f6-4716-a147-46a94fc90d7bn%40googlegroups.com > > <https://groups.google.com/d/msgid/bbedit/c2a16db0-85f6-4716-a147-46a94fc90d7bn%40googlegroups.com?utm_medium=email&utm_source=footer> > . > > -- This is the BBEdit Talk public discussion group. If you have a feature request or need technical support, please email "[email protected]" rather than posting here. Follow @bbedit on Twitter: <https://twitter.com/bbedit> --- You received this message because you are subscribed to the Google Groups "BBEdit Talk" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/bbedit/31b82c2a-3131-4c0b-8980-62dfaf2bf6b9n%40googlegroups.com.
