Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Select and copy .csv files based on row and column number
Top Forums UNIX for Beginners Questions & Answers Select and copy .csv files based on row and column number Post 303031267 by rcsapo on Monday 25th of February 2019 06:02:51 AM
Old 02-25-2019
Select and copy .csv files based on row and column number
Dear UNIX experts,

I'm a command line novice working on a Macintosh computer (Bash shell) and have neither found advice that is pertinent to my problem on the internet nor in this forum.

I have hundreds of .csv files in a directory. Now I would like to copy the subset of files that contains exactly 6 rows and 4 columns to a new directory. Since the .csv files are indeed comma-separated, I found that
Code:
awk -F',' ' { print NF }' test.csv

yields a column of 6 4's for the wanted files but I do not know how to make use of this output to select and copy numerous files in a loop.

I would be very grateful for any advice and apologize if I missed that a similar question had already been asked on this forum.

Thank you,
Robert
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Select Record based on First Column

Hi, I have a file with multiple records...and I have to select records based on first column....here is the sample file... I01,abc,125,1a2,LBVI02 I01,abc,126,2b5,LBVI02 I02,20070530,254,abc,LLBI01 I02,20070820,111,bvd,NGBI01 I need all records with I01 in first field in one file and... (8 Replies)
Discussion started by: mgirinath
8 Replies

2. Shell Programming and Scripting

Split single file into multiple files based on the number in the column

Dear All, I would like to split a file of the following format into multiple files based on the number in the 6th column (numbers 1, 2, 3...): ATOM 1 N GLY A 1 -3.198 27.537 -5.958 1.00 0.00 N ATOM 2 CA GLY A 1 -2.199 28.399 -6.617 1.00 0.00 ... (3 Replies)
Discussion started by: tomasl
3 Replies

3. Shell Programming and Scripting

How to print column based on row number

Hi, I want to print column value based on row number say multiple of 8. Input file: line 1 67 34 line 2 45 57 . . . . . . line 8 12 46 . . . . . . line 16 24 90 . . . . . . line 24 49 67 Output 46 90 67 (2 Replies)
Discussion started by: Surabhi_so_mh
2 Replies

4. Shell Programming and Scripting

delete a row in csv file based on the date

Hi, I have a csv file with old data..i need to have only last 30 days from the current dateof data in the file.The fourth field in the file is a date field.i need to write a script to delete the old data by comparing the the fourth field with the (current date -30).I need to delete the rows in... (2 Replies)
Discussion started by: pals70423
2 Replies

5. Shell Programming and Scripting

awk: Transpose csv row to column.

Hello, am I new to awk, and I am tryint to: INPUT FILE: "73423555","73423556","73423557","73423558","73423559" OUTPUT FILE: 73423555 73423556 73423557 73423558 73423559 My useless code so far: #!/bin/awk -F ',' BEGIN { i=0; } (8 Replies)
Discussion started by: drbiloukos
8 Replies

6. Shell Programming and Scripting

Read in 2-column CSV, output many files based on field

Is there a way to read in a two-columned CSV file, and based on the fields in 1st column, output many different files? The input/output looks something like: input.csv: call Call Mom. call Call T-Mobile. go Go home. go Go to school. go Go to gas station. play Play music. play Play... (4 Replies)
Discussion started by: pxalpine
4 Replies

7. Shell Programming and Scripting

Comparing Select Columns from two CSV files in UNIX and create a third file based on comparision

Hi , I want to compare first 3 columns of File A and File B and create a new file File C which will have all rows from File B and will include rows that are present in File A and not in File B based on First 3 column comparison. Thanks in advance for your help. File A A,B,C,45,46... (2 Replies)
Discussion started by: ady_koolz
2 Replies

8. Shell Programming and Scripting

List files with number to select based on number

Hi experts, I am using KSH and I am need to display file with number in front of file names and user can select it by entering the number. I am trying to use following command to display list with numbers. but I do not know how to capture number and identify what file it is to be used for... (5 Replies)
Discussion started by: mysocks
5 Replies

9. Shell Programming and Scripting

Row bind multiple csv files having different column headers

All, I guess by this time someone asked this kind of question, but sorry I am unable to find after a deep search. Here is my request I have many files out of which 2 sample files provided below. File-1 (with A,B as column headers) A,B 1,2 File-2 (with C, D as column headers) C,D 4,5 I... (7 Replies)
Discussion started by: ks_reddy
7 Replies

10. Shell Programming and Scripting

Get maximum per column from CSV file, based on date column

Hello everyone, I am using ksh on Solaris 10 and I'm gathering data in a CSV file that looks like this: 20170628-23:25:01,1,0,0,1,1,1,1,55,55,1 20170628-23:30:01,1,0,0,1,1,1,1,56,56,1 20170628-23:35:00,1,0,0,1,1,2,1,57,57,2 20170628-23:40:00,1,0,0,1,1,1,1,58,58,2... (6 Replies)
Discussion started by: ejianu
6 Replies

LEARN ABOUT DEBIAN

cdk_position

cdk_position(3) 					     Library Functions Manual						   cdk_position(3)

NAME

       cdk_position - curses widget positioning key-bindings

SYNOPSIS

       Position methods for the Cdk widgets allow the user to move the widget around the screen via the cursor/keypad keys.

DESCRIPTION

       The following key bindings can be used to move the widget around the screen.

					    +---------------------------------------------------------------+
					    |Key	       Action					    |
					    +---------------------------------------------------------------+
					    |Up Arrow	       Moves the widget up one row.		    |
					    |Down Arrow        Moves the widget down one row.		    |
					    |Left Arrow        Moves the widget left one column 	    |
					    |Right Arrow       Moves the widget right one column	    |
					    |1		       Moves  the  widget down one row and left one |
					    |		       column.					    |
					    |2		       Moves the widget down one row.		    |
					    |3		       Moves the widget down one row and right	one |
					    |		       column.					    |
					    |4		       Moves the widget left one column 	    |
					    |5		       Centers the widget both vertically and hori- |
					    |		       zontally.				    |
					    |6		       Moves the widget right one column	    |
					    |7		       Moves the widget up one	row  and  left	one |
					    |		       column.					    |
					    |8		       Moves the widget up one row.		    |
					    |9		       Moves  the  widget  up one row and right one |
					    |		       column.					    |
					    |t		       Moves the widget to the top of the screen.   |
					    |b		       Moves  the  widget  to  the  bottom  of	the |
					    |		       screen.					    |
					    |l		       Moves the widget to the left of the screen.  |
					    |r		       Moves the widget to the right of the screen. |
					    |c		       Centers	the  widget  between  the  left and |
					    |		       right of the window.			    |
					    |C		       Centers the widget between the top and  bot- |
					    |		       tom of the window.			    |
					    |Escape	       Returns the widget to its original position. |
					    |Return	       Exits  the  function  and  leaves  the  wid- |
					    |		       getwhere it was. 			    |
					    +---------------------------------------------------------------+
					    +---------------------------------------------------------------+
       The numbers 0-9 are chosen to correspond to the numeric keypad on your terminal.  Cdk does not handle the application mode  keypad  control
       sequences, since those are not defined via terminfo.  To use the numeric keypad you should ensure that it is in normal (or NumLock) mode.

SEE ALSO

       cdk(3), cdk_binding(3), cdk_display(3), cdk_screen(3)

																   cdk_position(3)
All times are GMT -4. The time now is 01:45 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy