Login or Register to Ask a Question and Join Our Community


UNIX for Dummies Questions & Answers

CSV connection

 
Thread Tools Search this Thread
Top Forums UNIX for Dummies Questions & Answers CSV connection
# 1  
Old 12-15-2015
CSV connection
hi guys,

actually i'm new for Unix. I have question How to connect CSV file to fetch the data by using "cut". and create new CSV to save that data??

please be needful

thanking you in Anticipation
# 2  
Old 12-15-2015
Not sure I understand. Be way more specific: Which separators are used? Which fields do you want to extract/save? Post samples of both input and desired output.
This User Gave Thanks to RudiC For This Post:
bhushan9991
# 3  
Old 12-15-2015
separator is ' , ' (comma) and in my csv I have 2 columns in first column there is DB1,DB2 and in second column 1,2. in second row first columns DB3,DB4 and in second column 3,4.
so I have to fetch this data and create another csv by using shell and save this data into 8 new columns.
e.g.
Code:
        DB1 1  DB2  2  DB3  3  DB4  4

Last edited by Don Cragun; 12-15-2015 at 02:38 PM.. Reason: Add CODE and ICODE tags.
# 4  
Old 12-15-2015
Still not clear. Above doesn't seem to describe a csv file. From what I guess, your task can't be done with cut. How are columns 1 and 2 separated?
# 5  
Old 12-15-2015
Code:
$ cat test.sh 
 #!/bin/bash IFS="," 
 while 
 read f1 f2 f3 
 do 
 echo "OS is : $f1" 
 echo "Company is : $f2" 
 echo "Value is : $f3" 
 done < file.csv

I tried this code It works but not properly....
Last edited by Don Cragun; 12-15-2015 at 02:35 PM.. Reason: Add CODE tags.
# 6  
Old 12-15-2015
Please use code tags as required by forum rules!

That code snippet doesn't help understanding your problem as it doesn't fit your data desription in post #3. Please post a data sample in code tags!
 
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Match columns from two csv files and update field in one of the csv file

Hi, I have a file of csv data, which looks like this: file1: 1AA,LGV_PONCEY_LES_ATHEE,1,\N,1,00020460E1,0,\N,\N,\N,\N,2,00.22335321,0.00466628 2BB,LES_POUGES_ASF,\N,200,200,00006298G1,0,\N,\N,\N,\N,1,00.30887539,0.00050312... (10 Replies)
Discussion started by: djoseph
10 Replies

2. Shell Programming and Scripting

Compare 2 csv files in ksh and o/p the difference in a new csv file

(say) I have 2 csv files - file1.csv & file2.csv as mentioned below: file1.csv ID,version,cost 1000,1,30 2000,2,40 3000,3,50 4000,4,60 file2.csv ID,version,cost 1000,1,30 2000,2,45 3000,4,55 6000,5,70 The... (7 Replies)
Discussion started by: Naresh101
7 Replies

3. Shell Programming and Scripting

Comparing 2 CSV files and sending the difference to a new csv file

(say) I have 2 csv files - file1.csv & file2.csv as mentioned below: file1.csv ID,version,cost 1000,1,30 2000,2,40 3000,3,50 4000,4,60 file2.csv ID,version,cost 1000,1,30 2000,2,45 3000,4,55 6000,5,70 ... (1 Reply)
Discussion started by: Naresh101
1 Replies

4. UNIX for Advanced & Expert Users

How keep running a program n an another computer via a connection ssh when the connection is closed?

Hi everybody, I am running a program on a supercomputer via my personal computer through a ssh connection. My program take more than a day to run, so when I left work with my PC I stop the connection with the supercomputer and the program stop. I am wondering if someone know how I can manage... (2 Replies)
Discussion started by: TomTomGre
2 Replies

5. Shell Programming and Scripting

Perl search csv fileA where two strings exist on another csv fileB

Hi I have two csv files, with the following formats: FileA.log: Application, This occured blah Application, That occured blah Application, Also this AnotherLog, Bob did this AnotherLog, Dave did that FileB.log: Uk, London, Application, datetime, LaterDateTime, Today it had'nt... (8 Replies)
Discussion started by: PerlNewbRP
8 Replies

6. Shell Programming and Scripting

CSV to SQL insert: Awk for strings with multiple lines in csv

Hi Fellows, I have been struggling to fix an issue in csv records to compose sql statements and have been really losing sleep over it. Here is the problem: I have csv files in the following pipe-delimited format: Column1|Column2|Column3|Column4|NEWLINE Address Type|some descriptive... (4 Replies)
Discussion started by: khayal
4 Replies

7. Solaris

Solaris 10 ftp connection problem (connection refused, connection timed out)

Hi everyone, I am hoping anyone of you could help me in this weird problem we have in 1 of our Solaris 10 servers. Lately, we have been having some ftp problems in this server. Though it can ping any server within the network, it seems that it can only ftp to a select few. For most servers, the... (4 Replies)
Discussion started by: labdakos
4 Replies

8. Shell Programming and Scripting

2 problems: Mailing CSV file / parsing CSV for display

I have been trying to find a good solution for this seemingly simple task for 2 days, and I'm giving up and posting a thread. I hope someone can help me out! I'm on HPUX, using sqlplus, mailx, awk, have some other tools available, but can't install stuff that isn't already in place (without a... (6 Replies)
Discussion started by: soldstatic
6 Replies

9. UNIX for Advanced & Expert Users

Connection reset by peer..closing connection

Hello I'm facing the above problem while doing a performance run. I've a script which I'm launching from my windows desktop using mozilla. The script will invoke backend action on a Solaris host which in turn feeds the records to a driver located on a linux box(Cent OS). What's happening is... (1 Reply)
Discussion started by: subramanyab
1 Replies

10. Shell Programming and Scripting

Need to compare two csv files values and write into another csv file

Hi all, Am new to scripting. So i just need your ideas to help me out. Here goes my requirement. I have two csv files 1.csv 2.csv abc,1.24 abc,1 def,2.13 def,1 I need to compare the first column of 1.csv with 2.csv and if matches then need to compare... (2 Replies)
Discussion started by: chinnahyd
2 Replies
Login or Register to Ask a Question