Inserting quotes to pipe separated line using sed

Question

I have a custom made tool that parses XML files using SAX and that reproduces them into pipe separated values, an example of a line would be:

name|lastname|address|telephone|age|other info|other info

I would like to rewrite each line, i will do this using a bash script but i'm having some difficulties. Basically i would like to set each word between quotes, an example for the above line would be:

"name"|"lastname"|"address"|"telephone"|"age"|"other info"|"other info"

i'm trying to do this using sed, and i'm partially successful with this sed line

sed 's:|:"|":g'

as i get the output: name"|"lastname"|"address"|"telephone"|"age"|"other info"|"other info

but i dont know how to set quotes for the first char and the last char, Any advice?

Answer 1

You were definitely on the right track, Here's how to cover the special cases of beginning of line, end of line:

 sed 's:|:"|":g;s/^/"/;s/$/"/'

^ char anchors search to beginning of line, the $ char anchors search at the end of the line.

IHTH