Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Reg - Working on a CSV File in a script

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Reg - Working on a CSV File in a script
# 15  
Old 04-23-2013
Quote:
Originally Posted by rrb2009
I think I posted the files in my original post and I am posting it again for your reference.

1st CSV File
Code:
ColumnA,ColumnB,ColumnC  
Client 1,XXXXX,Server A 
Client 2,XXXXX,Server B  
Client 3,XXXXX,Server C
Client 4,XXXXX,Server C
Client 5,XXXXX,Server B
Client 6,XXXXX,Server C

[..]
Well except for the fact that they use different field separators. The sample in the first post appears to use TAB as field separator, which I used in my suggestion and this one uses a comma..
Login or Register to Ask a Question

Previous Thread | Next Thread

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Save output of updated csv file as csv file itself, part 2

Hi, I have another problem. I want to sort another csv file by the first field. result.csv SourceFile,Airspeed,GPSLatitude,GPSLongitude,Temperature,Pressure,Altitude,Roll,Pitch,Yaw /home/intannf/foto5/2015_0313_090651_219.JPG,0.,-7.77223,110.37310,30.75,996.46,148.75,180.94,182.00,63.92 ... (2 Replies)
Discussion started by: refrain
2 Replies

2. Shell Programming and Scripting

Compare 2 files of csv file and match column data and create a new csv file of them

Hi, I am newbie in shell script. I need your help to solve my problem. Firstly, I have 2 files of csv and i want to compare of the contents then the output will be written in a new csv file. File1: SourceFile,DateTimeOriginal /home/intannf/foto/IMG_0713.JPG,2015:02:17 11:14:07... (8 Replies)
Discussion started by: refrain
8 Replies

3. Shell Programming and Scripting

Remove ^L from csv not working...

hello... i have a requirement to convert a xls file to csv in RHEL 6.5 and ftp it to a windows location. i am using xls2csv utility to convert the file in linux. Input xls file attached... I have used below commands to convert the file to csv: xls2csv -x test.xls -s cp1252 -d 8859-1... (3 Replies)
Discussion started by: rhel65
3 Replies

4. UNIX for Dummies Questions & Answers

Remodelling the .csv file using the script

Hello All, I have a .csv file named as remark.csv The csv file content looks like below: Remark_Hello_1 Remark_Hello_2 Remark_Hello_3 Remark_Hello_4 Hello_World_FW_0001 X Hello_World_FW_0002 X X Hello_World_FW_0003 X X Hello_World_FW_0004 X X I... (5 Replies)
Discussion started by: suvendu4urs
5 Replies

5. Shell Programming and Scripting

Script to generate csv file

Hello; I need to generate a csv file that contains a list of all the files in a particular server (from the root directory ie: \) that have a permission stamp of 777. I would like to create the csv so that it contains the following: server name, file name, full path name where file exists,... (17 Replies)
Discussion started by: gvolpini
17 Replies

6. Shell Programming and Scripting

Conversion of below Tabs Tex file into CSV format file : shell script needed

Request if some one could provide me shell script that converts the below "input file" to "CSV format file" given Name Domain Contact Phone Email Location ----------------------- ------------------------------------------------ ------- ----- ---------------------------------... (7 Replies)
Discussion started by: sreenath1037
7 Replies

7. Shell Programming and Scripting

How to convert a excel file to a .csv file from unix script

Hi I have a excel file in unix machine and have to convert it into a .csv file.I have to do this from a unix script.How do we do this? Thanks Abhinav (3 Replies)
Discussion started by: akashtcs
3 Replies

8. Shell Programming and Scripting

Shell Script to Load data into the database using a .csv file and .ctl file

Since i'm new to scripting i'm findind it difficult to code a script. The script has to be an executable with 2 paramters passed to it.The Parameters are 1. The Control file name(.ctl file) 2. The Data file name(.csv file) Does anybody have an idea about it? :confused: (3 Replies)
Discussion started by: Csmani
3 Replies

9. SCO

reg:rm -R is not working

I am installing the my package in SCO unix 5.0 .so it will create some temporary directories and files and same will delete.So , 'rm -R ' is not working in system .in the package only it has given this command,so now without this command working we can not go forward. so kindly help in this... (1 Reply)
Discussion started by: mokri_1980
1 Replies
Login or Register to Ask a Question

LEARN ABOUT REDHAT

dlags2

DLAGS2(l)								 )								 DLAGS2(l)

NAME

       DLAGS2 - compute 2-by-2 orthogonal matrices U, V and Q, such that if ( UPPER ) then  U'*A*Q = U'*( A1 A2 )*Q = ( x 0 ) ( 0 A3 ) ( x x ) and
       V'*B*Q = V'*( B1 B2 )*Q = ( x 0 ) ( 0 B3 ) ( x x )  or if ( .NOT.UPPER ) then  U'*A*Q = U'*( A1 0 )*Q = ( x x ) ( A2 A3	)  (  0  x  )  and
       V'*B*Q = V'*( B1 0 )*Q = ( x x ) ( B2 B3 ) ( 0 x )  The rows of the transformed A and B are parallel, where  U = ( CSU SNU ), V = ( CSV SNV
       ), Q = ( CSQ SNQ ) ( -SNU CSU ) ( -SNV CSV ) ( -SNQ CSQ )  Z' denotes the transpose of Z

SYNOPSIS

       SUBROUTINE DLAGS2( UPPER, A1, A2, A3, B1, B2, B3, CSU, SNU, CSV, SNV, CSQ, SNQ )

	   LOGICAL	  UPPER

	   DOUBLE	  PRECISION A1, A2, A3, B1, B2, B3, CSQ, CSU, CSV, SNQ, SNU, SNV

PURPOSE

       DLAGS2 computes 2-by-2 orthogonal matrices U, V and Q, such that if ( UPPER ) then U'*A*Q = U'*( A1 A2 )*Q = ( x 0 ) ( 0 A3 ) ( x x  )  and
       V'*B*Q  = V'*( B1 B2 )*Q = ( x 0 ) ( 0 B3 ) ( x x ) or if ( .NOT.UPPER ) then U'*A*Q = U'*( A1 0 )*Q = ( x x ) ( A2 A3 ) ( 0 x ) and V'*B*Q
       = V'*( B1 0 )*Q = ( x x ) ( B2 B3 ) ( 0 x ) The rows of the transformed A and B are parallel, where U = ( CSU SNU ), V = ( CSV SNV ), Q = (
       CSQ SNQ ) ( -SNU CSU ) ( -SNV CSV ) ( -SNQ CSQ ) Z' denotes the transpose of Z.

ARGUMENTS

       UPPER   (input) LOGICAL
	       = .TRUE.: the input matrices A and B are upper triangular.
	       = .FALSE.: the input matrices A and B are lower triangular.

       A1      (input) DOUBLE PRECISION
	       A2	(input)  DOUBLE  PRECISION A3	   (input) DOUBLE PRECISION On entry, A1, A2 and A3 are elements of the input 2-by-2 upper
	       (lower) triangular matrix A.

       B1      (input) DOUBLE PRECISION
	       B2      (input) DOUBLE PRECISION B3	(input) DOUBLE PRECISION On entry, B1, B2 and B3 are elements of the  input  2-by-2  upper
	       (lower) triangular matrix B.

       CSU     (output) DOUBLE PRECISION
	       SNU     (output) DOUBLE PRECISION The desired orthogonal matrix U.

       CSV     (output) DOUBLE PRECISION
	       SNV     (output) DOUBLE PRECISION The desired orthogonal matrix V.

       CSQ     (output) DOUBLE PRECISION
	       SNQ     (output) DOUBLE PRECISION The desired orthogonal matrix Q.

LAPACK version 3.0						   15 June 2000 							 DLAGS2(l)