10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I have an input file as below
1234|FirstName1|MiddleName2|LastName3| Add1 || ADD2|123|000000000
1234|FirstName1|MiddleName2|LastName3| Add1 ,, ADD2|123|000000000
1234,FirstName1,MiddleName2,LastName3, Add1 ||... (2 Replies)
Discussion started by: styris
2. Shell Programming and Scripting
I need to remove first column from a csv file and i can do this by using below command.
cut -f1 -d, --complement Mytest.csv
I need to implement this in shell scripting, Whenever i am using the above command alone in command line it is working fine.
I have 5 files in my directory and... (3 Replies)
Discussion started by: Samah
3. Shell Programming and Scripting
I have a file which has data like
And I need to insert a new column at the begining with sequence no( 1 to n)
Please let me know how to acheive this in unix (3 Replies)
Discussion started by: weknowd
4. Shell Programming and Scripting
Hi All ,
I have pipe delimiter file with 11 columns . I need to insert 4 empty columns after column 10 . and After 11 column I need to insert a column which is having the same value for all the rows .
... (11 Replies)
Discussion started by: Hypesslearner
5. Shell Programming and Scripting
I have a pipe delimited file as below and I need to replace the 2nd column of each line with null values.
I tried this
... (2 Replies)
Discussion started by: member2014
6. Shell Programming and Scripting
Thanks for taking time to read through the thread and for providing any possible solution.
I am trying to pivot a comma separated field in a pipe delimited file. Data looks something like this:
Desired... (8 Replies)
Discussion started by: svks1985
7. Homework & Coursework Questions
I have pipe delimited flat file as below
i want to show (display) only 3rd field between pipes.
please help (1 Reply)
Discussion started by: vai15517
8. Shell Programming and Scripting
this is Korn shell unix.
The scenario is I have a pipe delimited text file which needs to be customized. say for example,I have a pipe delimited text file with 15 columns(| delimited) and 200 rows. currently the 11th and 12th column has null values for all the records(there are other null columns... (4 Replies)
Discussion started by: vasan2815
9. 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
10. UNIX for Dummies Questions & Answers
I have a text file date(pipe delimited) which is loaded in to the DB using sql loader(&CTL files) after some initial validation by the shell script.
Now i have a situation where the shell script needs to check a column in the text file and if it is NULL then it needs send this record/row... (12 Replies)
Discussion started by: ravi0435