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
TextPad - Tab-delimited file changed to comma-delimited
Moderators: AmigoJack, bbadmin, helios, MudGuard
-
ben_josephs
- Posts: 2464
- Joined: Sun Mar 02, 2003 9:22 pm
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
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
orFind what: <tab> (where <tab> is a lteral tab)
Replace with: ,
Replace All
Find what: \t
Replace with: ,
[X] Regular expression
Replace All