10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I am trying to parse two csv files and make a match in one column then print the entire file to a new file and append an additional column that gives description from the match to the new file. If a match is not made, I would like to add "NA" to the end of the file
Command that Ive been using... (6 Replies)
Discussion started by: dis0wned
2. UNIX for Beginners Questions & Answers
I'm trying to use awk to count the occurrences of two matching fields of a CSV file.
For instance, for data that looks like this...
I've been trying to use code like this...
countvar=`awk ' $2~/$color/... (4 Replies)
Discussion started by: nmoore2843
3. Emergency UNIX and Linux Support
I have a csv file which is produced out of a SED command sed 's/|/","/g; s/^/"/; s/$/"/' A4.txt > A5.csv and I need either an addition to the SED command or a separate command to convert the following characters which occur within the fields in multiple lines
1) "=" to ="
2)""~ to " (4 Replies)
Discussion started by: etldev
4. Shell Programming and Scripting
i have a csv file which have headers and values of it like below :
headers --> CI Ref SerialNumber LastScanDate
values --> VMware-42,VMware-42,Tue, 20 May 2014 11:03:44 +0000
i want to have a above csv in below format :
headers --> CI Name CI Description CI Ref... (6 Replies)
Discussion started by: omkar.jadhav
5. Shell Programming and Scripting
Hi Tech Guru,
I have a test file as below , which needs some more fields to be populated randomly :
... (8 Replies)
Discussion started by: Lokesha
6. Shell Programming and Scripting
I have a csv file which I need to insert addtional commas into. The csv is of the format
I need to add extra commas in each record so that the final output looks like
... (1 Reply)
Discussion started by: kamal_p_99
7. Shell Programming and Scripting
I want to remove the rows from File1.csv by comparing the columns/fields in the File2.csv. I only need the records whose first column is same and the second column is different for the same record in both files.Here is an example on what I need.
RAJAK|ACTIVE|1... (2 Replies)
Discussion started by: rajak.net
8. Shell Programming and Scripting
I have a requirment where I need to pull different columns from a .csv file.
Here is the sample of the csv file.
I will be have a config.txt file which will have the following information.
item,flag5,flag10,feed,tran... (2 Replies)
Discussion started by: akdevula
9. Shell Programming and Scripting
I have 3 separate files within a folder. Every File contains data in a single column like
File1 contains data
File3 contains data
232323 (2 Replies)
Discussion started by: mayanksargoch
10. UNIX for Dummies Questions & Answers
I need to insert data into a perticular field of a csv file, lets say second field.
Can any one help me to do this?
I found that we can do it with sed. can any one guide me to accomplish this?
thanks in advance. (12 Replies)
Discussion started by: praveen_b744