Convert pipe demilited file to vertical tab delimited

Shell Programming and Scripting
1

Hi All,

How can we convert pipe delimited ( or comma ) file to vertical tab (VT) delimited.

Regards
PK

2

Use the tr -utility to replace one specific (delimiter) character with another. As long as there are no additional complications (see below) this would suffice. Consult the man page of tr for details.

Notice, that, depending on you input data, it might be more complicated than that: Suppose your input looks like:

field1|field2|"field|3"|field4|...

and you want to skip the quoted pipe inside field3 you will have to use a parser. Anything short of such a program will not be fully able to "understand" your input and translate the separator characters into different ones accordingly.

I hope this helps.

bakunin

3

Hi,

Thanks for your reply.

I have pipe delimited file and i want to convert pipe to Vertical Tab demilted.

What ascii character i need to give for vertical tab.

4

man ascii or look here

5

I think you should seriously take note of bakunin's #2 reply; ignore it at your peril...
If you think that a simple use of something like tr '|' '\v' command might work you could well end up with a well corrupt file.