10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I have file in linux with comma delimited and string fields in double quotations ", I need to convert them to pipe delimiter please share your inputs.
"2017-09-30","ACBD,TVF","01234",NULL,18,NULL,"686091802","BANK OF ABCD, LIMITED, THE",790456
... (4 Replies)
Discussion started by: shieksir
2. Shell Programming and Scripting
How can we convert pipe delimited ( or comma ) file to vertical tab (VT) delimited.
PK (4 Replies)
Discussion started by: prasson_ibm
3. Shell Programming and Scripting
Hello, I need to get few values from a XML file and output needs to be written in another file with pipe delimited format. The Header & Footer of the Pipe Delimited file will be constant.
The below is my sample XML file. I need to pull the values in between the XML tags <Operator_info to... (15 Replies)
Discussion started by: karthi1305561
4. UNIX for Dummies Questions & Answers
Hi, I have a rquirement in unix as below .
I have a text file with me seperated by | symbol and i need to generate a excel file through unix commands/script so that each value will go to each column.
Input Text file:
excel file to be generated as output as... (9 Replies)
Discussion started by: raja kakitapall
5. Shell Programming and Scripting
I have a text file with space and tab (mixed) delimited file and need to convert into CSV.
# cat test.txt
/dev/rmt/tsmmt32 HP Ultrium 6-SCSI J3LZ 50:03:08:c0:02:72:c0:b5 F00272C0B5 0/0/6/1/22.214.171.124.0.0.0 /dev/rmt/c102t0d0BEST
/dev/rmt/tsmmt37 ... (6 Replies)
Discussion started by: prvnrk
6. Shell Programming and Scripting
Hi How to make tab delimited file to space delimited?
in put file:
Use code tags, thanks. (1 Reply)
Discussion started by: jagdishrout
7. Shell Programming and Scripting
I have a file which was pipe delimited, I need to make it tab delimited. I tried with sed but no use
cat file | sed 's/|//t/g'
The above command substituted "/t" not tab in the place of pipe.
have to convert to:
abc 123... (6 Replies)
Discussion started by: karumudi7
8. Shell Programming and Scripting
Hi, could some help me convert CSV file (with double quoted strings) to pipe delimited file:
here you go with the same data:
1,Friends,"$3.99 per 1,000 listings",8158here " 1,000 listings " should be a single field.
Ram (8 Replies)
Discussion started by: Ram.Math
9. Shell Programming and Scripting
i have a file whose data is like this::
email@example.com|4|... (6 Replies)
Discussion started by: priyanka3006
10. UNIX for Dummies Questions & Answers
I have a file with single white space delimited values, I want to convert them to a tab delimited file.
I tried sed, tr ... but nothing is working.
Rajeevan D (16 Replies)
Discussion started by: jeevs81