10 More Discussions You Might Find Interesting
1. 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
2. Shell Programming and Scripting
Thank you for 4 looking this post.
We have a tab delimited file where we are facing problem in a lot of funny character. I have tried using awk but failed that is not working.
In the 5th field ID which is supposed to be a integer only of that file, we are getting corrupted data as below.
I... (12 Replies)
Discussion started by: Srithar
3. Shell Programming and Scripting
Hi some one please help me to remove duplicates from a pipe delimited file based on first two columns.
Here My first record and last record are duplicates.As per my requirement I want all the latest records into one file.
I want the... (12 Replies)
Discussion started by: ginrkf
4. Shell Programming and Scripting
I have file as below
i need to remove column2,3, from that file
. (3 Replies)
Discussion started by: greenworld123
5. Shell Programming and Scripting
I am trying to find the lines in a pipe delimited file where 11th column has not null values. Any help is appreciated. Need help asap please.
thanks in advance. (3 Replies)
Discussion started by: manikms
6. UNIX for Dummies Questions & Answers
I have a file where I should search for a string and get the rest of the line but without the delimiter using awk.
for example I have the series of string in a file:
and the mapping file looks like this.
ccc|43... (11 Replies)
Discussion started by: kokoro
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
I have a simple challenge for you.. I have the following pipe delimited file
... (2 Replies)
Discussion started by: nithins007
9. Shell Programming and Scripting
This is my input file with extra information in the HEADER and leading & trailing SPACES between PIPE delimiter.
02/04/2010 Dynamic List Display 1
--------------------------------------------------------------------------------------... (6 Replies)
Discussion started by: srimitta
10. Shell Programming and Scripting
I have a pipe delimited file having 5 columns.
However the column no-3 is having extra new line characters as the data owing to owing , I am having issues.
Ideally my file should have only newline termination at the end of each record and not within column data of any of... (1 Reply)
Discussion started by: sureshg_sampat