I continue to be perplexed with CRLF and BBedit and Excel.
I exported a table from Access. Some of that data has whatever carriage returns and line feeds that Accces uses to designate a paragraph.
I open it in excel, it's fine. Copy it to BBedit,do some grep, paste it back in all the carriage turns make the data populate multiple cells.
What is the magic F/Replace I need to do in BBedit that will let me paste everything back into excel. Everything I read says use CRLF as that's windows but in BBedit that seems to be \r and \n which excel sees as pressing the Return key.
What is the missing magic step. Please.
-- You received this message because you are subscribed to the "BBEdit Talk" discussion group on Google Groups. To post to this group, send email to bbedit@googlegroups.com To unsubscribe from this group, send email to bbedit+unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/bbedit?hl=en If you have a feature request or would like to report a problem, please email "support@barebones.com" rather than posting to the group.
To unsubscribe from this group, send email to bbedit+unsubscribegooglegroups.com or reply to this email with the words "REMOVE ME" as the subject.
Mar 26
Charlie Garrison Re: BBedit to Excel... (to Access)
Mar 26, 2010; 07:12
Charlie Garrison
Re: BBedit to Excel... (to Access)
Mar 26
John Delacour Re: BBedit to Excel... (to Access)
Mar 26, 2010; 13:41
John Delacour
Re: BBedit to Excel... (to Access)
Search
Lasso Programming
This site manages and broadcasts several email lists pertaining to Lasso Programming and technologies related and used by Lasso developers. Sign up today!