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 <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] > <mailto:[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/092D76D8-6DBE-4C0B-AB61-C73EC7100EF9%40gmail.com.
