I do this all the time, but doing it in BBedit can mess up where the data goes related to the column. I keep the data in Excel and use =SUBSTITUTE(B2,CHAR(10),"|") Sub out B2 with your column. I try and replace with something very distinctive. I used a pipe in the above. NOTE: A hard return would be CHAR(13) instead of CHAR(10) After I run that I copy and paste the values. Lastly Data->Text to Columns and use the pipe to delimit. One final note: Excel will leave the pipe in the delimit option until you change it back to use a tab. That can be unexpected the next time you go to paste tab delimited copy. I am also going to attach my Excel ASCII Chart for reference. On Friday, September 24, 2021 at 3:34:00 PM UTC-4 Christopher Waterman wrote:
> Russell > > Have you tried the command Text: Zap Gremlins ? > > --Chris(topher)? > > On Sep 24, 2021, at 5:32 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/e136605e-7698-4f05-8f62-045b71ead53an%40googlegroups.com.
ASCII Chart.xlsx
Description: MS-Excel 2007 spreadsheet
