You can regex it certainly but why not just open it in Excel and then
save it as text?
For regexing I'd do something like this off the top of my head:
First change all situations where it should be (presumably) to tab-
delimited with
Search For:
(",")
Replace With:
\t
Then remove all those quotations at the beginning and end of each line:
Search For:
^"
Replace With:
and
Search For:
"$
Replace With:
You can do all those with one function but it is a little more
complicated
John
On Feb 18, 2008, at 11:51 AM, Dean Matthews wrote:
I need to convert a CSV file to delimited.
There are commas that should not be converted i.e. "Joe Smith, Phd"
These commas are enclosed in quotes as above.
How can I replace the commas with tabs without affecting the commas
enclosed in quotes?
Thanks,
Dean
--
------------------------------------------------------------------
Have a feature request? Not sure the software's working correctly?
If so, please send mail to <[EMAIL PROTECTED]>, not to the list.
List FAQ: <http://www.barebones.com/support/lists/bbedit_talk.shtml>
List archives: <http://www.listsearch.com/BBEditTalk.lasso>
To unsubscribe, send mail to: <[EMAIL PROTECTED]>
--
------------------------------------------------------------------
Have a feature request? Not sure the software's working correctly?
If so, please send mail to <[EMAIL PROTECTED]>, not to the list.
List FAQ: <http://www.barebones.com/support/lists/bbedit_talk.shtml>
List archives: <http://www.listsearch.com/BBEditTalk.lasso>
To unsubscribe, send mail to: <[EMAIL PROTECTED]>
