Page 1 of 1
TextPad - Tab-delimited file changed to comma-delimited
Posted: Fri Jul 23, 2010 6:47 pm
by rockycj
I have a tab-delimited file and I need it changed to a comma-delimited (CSV) file. So all of the tabs between each column need to be replaced with a comma instead. Is there a way to do this within TextPad?
Could someone help me or give me some instructions on how to do this?
Thank you!
CC
Posted: Fri Jul 23, 2010 7:27 pm
by ben_josephs
Use
Search | Replace... (<F8>).
You can search for a tab by copying a literal tab from anywhere (for example, the document you are currently editing) and pasting it into the
Find what edit box. Alternatively, you can use regular expressions and search for
\t.
Unfortunately, TextPad only recognises escape sequences such as
\t when it's searching using regular expressions (although whether it should use regular expressions and whether it should interpret escape sequenecs are distinct questions).
So you can use
Find what: <tab> (where <tab> is a lteral tab)
Replace with: ,
Replace All
or
Find what: \t
Replace with: ,
[X] Regular expression
Replace All