Auto replacing tab delimiters with pipe delimiters?

[Dan Sabo]

Hi,

Does anyone know if there is a way to replace tab delimiters with pipe delimiters automatically in Text Pad? How to do it?

Seems like a very nice application!

[Andreas]

Do a search/Replace.
Search for
\t
replace by
|
make sure Regex is checked.

[Dan Sabo]

OK thanks very much.

What does Regex do?

[Sam]

Regex is short for Regular Expression. Its a search string that uses special characters to match patterns of text. Common in UNIX. NOT checking the box will cause Find/Replace to look for the characters '\t' instead of a tab.

[Dan Sabo]

OK so I just should have checked the regular expression box and placed the /t in the find box. Thanks.

I was wondering though, instead of using the /t as the symbol for the tab, I instead just highlighted a tab space and a wide pipe showed up in the find box - I assume representing the tabbed space. And for the replace character I placed the |, and it seemed to work, and replaced all the tabs with the pipes. I was wondering would this cause any problems in my database if I did it this way instead? Is this a good method?

[Andreas]

not /t
but \t