Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Splitting input CSV file into 3 files
Top Forums Shell Programming and Scripting Splitting input CSV file into 3 files Post 302710269 by Don Cragun on Thursday 4th of October 2012 07:08:01 AM
Old 10-04-2012
Quote:
Originally Posted by elixir_sinari
Code:
awk 'FNR==NR{lc1=FNR;next}
FNR<=3{print > "file1.csv";next}
FNR>=(lc1-3){print > "file3.csv";next}
{print > "file2.csv"}' file file

I think this puts the last 4 lines of file in file3.csv; not the last 3 lines. I believe the line writing file3.csv needs to be one of the following:
Code:
FNR>(lc1-3){print > "file3.csv";next}
        or
FNR>=(lc1-2){print > "file3.csv";next}

 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Splitting input files into multiple files through AWK command

Hi, I needs to split *.txt files from single directory depends on the some mutltiple input values. i have wrote the code like below for file in *.txt do grep -i -h "value1|value2" $file > $file; done. My requirment is more input values needs to be given in grep; let us say 50... (3 Replies)
Discussion started by: arund_01
3 Replies

2. Shell Programming and Scripting

how to give multiple csv files as input in awk

Hi All, I am new to shell scripting..My problem is i want to give multiple csv files as input to awk script and process the data into one file.. My input file is File1 File2 File3 Product Location Period SalesPrice A x 8/11/2010 ... (7 Replies)
Discussion started by: kvth
7 Replies

3. UNIX for Advanced & Expert Users

Splitting the single csv file

Hi, I have a requiement where in i will get a single file but there will be mutiple headers. Suppose say for eg: Header1 Data... Data... Header2 Data.. Data.. Header3 Data.. Data.. I want to split each with the corresponding data into a single file. Please let me know how... (1 Reply)
Discussion started by: weknowd
1 Replies

4. Shell Programming and Scripting

How to generate a csv files by separating the values from the input file based on position?

Hi All, I need help for doing the following. I have a input file like: aaaaaaaaaabbbbbbbbbbbbbbbbbbbb cccbbbbbaaaaaadddddaaaabbbbbbb now I am trying to generate a output csv file where i will have for e.g. 0-3 chars of each line as the first column in the csv, 4-10 chars of the line as... (3 Replies)
Discussion started by: babom
3 Replies

5. 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

6. 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

7. 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

8. Open Source

Splitting files using awk and reading filename value from input data

I have a process that requires me to read data from huge log files and find the most recent entry on a per-user basis. The number of users may fluctuate wildly month to month, so I can't code for it with names or a set number of variables to capture the data, and the files are large so I don't... (7 Replies)
Discussion started by: rbatte1
7 Replies

9. Shell Programming and Scripting

Splitting CSV into variables then to XML file

I have a text file that looks like this: FIELD1, FIELD2, THIS IS FIELD3, FIELD4 FIELD1, FIELD2, THIS IS FIELD3, FIELD4 FIELD1, FIELD2, THIS IS FIELD3, FIELD4 I need it to turn it into an XML file to run against a custom application. My ultimate goal is for it to look like... (15 Replies)
Discussion started by: jeffs42885
15 Replies

10. Shell Programming and Scripting

Splitting csv into 3 tables in html file

I have the data in csv in 3 tables. how can I output the same into 3 tables in html.also how can I set the width. tried multiple options . attached is the format. #!/bin/ksh awk 'BEGIN{ FS="," print "<HTML><BODY><TABLE border = '1' cellpadding=10 width=100>" print... (7 Replies)
Discussion started by: archana25
7 Replies

LEARN ABOUT REDHAT

clags2

CLAGS2(l)								 )								 CLAGS2(l)

NAME

       CLAGS2  -  compute  2-by-2 unitary 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 ) where  U = ( CSU SNU ), V = ( CSV SNV ),

SYNOPSIS

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

	   LOGICAL	  UPPER

	   REAL 	  A1, A3, B1, B3, CSQ, CSU, CSV

	   COMPLEX	  A2, B2, SNQ, SNU, SNV

PURPOSE

       CLAGS2  computes  2-by-2  unitary  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 ) where U = ( CSU SNU ), V = ( CSV SNV ),	 ( -CONJG(SNU)	CSU )	   ( -CONJG(SNV) CSV )

	 Q = (	   CSQ	    SNQ )
	     ( -CONJG(SNQ)  CSQ )

       Z' denotes the conjugate transpose of Z.

       The rows of the transformed A and B are parallel. Moreover, if the input 2-by-2 matrix A is not zero, then the transformed (1,1) entry of A
       is not zero. If the input matrices A and B are both not zero, then the transformed (2,2) element of B is not zero, except  when	the  first
       rows of input A and B are parallel and the second rows are zero.

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) REAL
	       A2	(input)  COMPLEX  A3	   (input)  REAL On entry, A1, A2 and A3 are elements of the input 2-by-2 upper (lower) triangular
	       matrix A.

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

       CSU     (output) REAL
	       SNU     (output) COMPLEX The desired unitary matrix U.

       CSV     (output) REAL
	       SNV     (output) COMPLEX The desired unitary matrix V.

       CSQ     (output) REAL
	       SNQ     (output) COMPLEX The desired unitary matrix Q.

LAPACK version 3.0						   15 June 2000 							 CLAGS2(l)
All times are GMT -4. The time now is 08:53 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy