After a bit of testing I got the file out of a very old password manager in txt format, into FileMaker to clean and cull and then out to Excel via csv that LastPass was happy with. There were 500 entries in the pw manager so that's why it was worth the effort. I've been in IT too long! Even though Excel was not wrapping the comments field contents, a copy and paste of the comments field into BBE confirmed they were still there and LastPass displayed the returns.
On Saturday, September 25, 2021 at 1:43:46 PM UTC+10 Harvey Pikelberger wrote: > Re: LastPass > > Cool. Looking forward to hearing how it goes > > Depending on your use case FMP has built in encryption/decryption, so if > it's only for yourself it can serve as your keychain. > > On Sep 24, 2021, at 19:39, Russell B <[email protected]> wrote: > > 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 > > <https://groups.google.com/d/msgid/bbedit/31b82c2a-3131-4c0b-8980-62dfaf2bf6b9n%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/441487c4-817f-47a2-9219-bdad1e23029dn%40googlegroups.com.
