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 303031271 by RudiC on Monday 25th of February 2019 06:33:08 AM
Old 02-25-2019
Welcome to the forum.


I'm afraid it's not that easy and straightforward as you assumed. Still it's not a major problem. Try
Code:
awk -F',' '
FNR == 1        {if (NFOK && (OLDFNR == 6)) print "echo cp -v " OLDFN " new_dir/"
                 NFOK = 1
                }
NF != 4         {NFOK = 0
                }
                {OLDFNR = FNR
                 OLDFN  = FILENAME
                }
END             {if (NFOK && (OLDFNR == 6)) print  "echo cp -v " OLDFN " new_dir/"
                }
 ' *.csv | sh

This runs through all the .csv files in your current working dir, checks if each consistently has four fields in each line, and exactly 6 lines, and, for each match, prints a copy command into the pipe for the subsequently running shell.
When happy with what you see, you can remove the echo so the real copy is executed.
Last edited by RudiC; 02-25-2019 at 07:38 AM..
 

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 LINUX

shtool-echo

SHTOOL-ECHO.TMP(1)					      GNU Portable Shell Tool						SHTOOL-ECHO.TMP(1)

NAME

       shtool-echo - GNU shtool echo(1) extensional command

SYNOPSIS

       shtool echo [-n|--newline] [-e|--expand] string

DESCRIPTION

       shtool echo is an echo(1) style command which prints string to stdout and optionally provides special expansion constructs (terminal bold
       mode, environment details, date, etc) and newline control. The trick of this command is that it provides a portable -n option and hides the
       gory details needed to find out the environment details under option -e.

OPTIONS

       The following command line options are available.

       -n, --newline
	   By default, output is written to stdout followed by a "newline" (ASCII character 0x0a). If option -n is used, this newline character is
	   omitted.

       -e, --expand
	   If option -e is used, string can contain special "%x" constructs which are expanded before the output is written. Currently the
	   following constructs are recognized:

	   %B  switch terminal mode to bold display mode.

	   %b  switch terminal mode back to normal display mode.

	   %u  the current user name.

	   %U  the current user id (numerical).

	   %g  the current group name.

	   %G  the current group id (numerical).

	   %h  the current hostname (without any domain extension).

	   %d  the current domain name.

	   %D  the current day of the month.

	   %M  the current month (numerical).

	   %m  the current month name.

	   %Y  the current year.

EXAMPLE

	#   shell script
	shtool echo -n -e "Enter your name [%B%u%b]: "; read name
	shtool echo -e "Your Email address might be %u@%h%d"
	shtool echo -e "The current date is %D-%m-%Y"

HISTORY

       The GNU shtool echo command was originally written by Ralf S.  Engelschall <rse@engelschall.com> in 1998 for Website META Language (WML)
       under the name buildinfo. It was later taken over into GNU shtool.

SEE ALSO

       shtool(1), echo(1).

18-Jul-2008							   shtool 2.0.8 						SHTOOL-ECHO.TMP(1)
All times are GMT -4. The time now is 06:24 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy