Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Content of filtered files write as columns into one file
Top Forums Shell Programming and Scripting Content of filtered files write as columns into one file Post 302944667 by Don Cragun on Thursday 21st of May 2015 04:59:42 AM
Old 05-21-2015
You might want to try this instead:
Code:
#!/bin/bash
awk '
FNR == 1 {
	close(fn)
	seq = substr(FILENAME, 8, 3)
	fn = "test" FILENAME ".txt"
	printf("%-13s\n", seq) > fn
}
FNR == 8 || FNR == 10 || (FNR >= 13 && FNR <= 268) {
	printf("%-13s\n", $0) > fn
}' sample_*.Spe
paste -d ' ' testsample_*.Spe.txt > test_f.txt

It invokes awk once instead of 80 times, creates each of your testsample_*.Spe.txt files once instead of twice, invokes paste once instead of 80 times, and doesn't redirect the output of paste to one of its input files (which wiped out most of the work you were trying to do).

This assumes that your data doesn't have any fields wider than 13 characters and that you want data left aligned in each column (which matches the 1st two columns of output in your second sample output file.
This User Gave Thanks to Don Cragun For This Post:
IMPe
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

sorting file content on columns

guys i have a question: i'd like to sort files (as many I want) in columns so to visualize them one near the other...so let's say i have just 2 files: FILE1 John Mary Bridget FILE2 Anne Robert Mark i would like to obtain: John Anne Mary Robert Bridget ... (2 Replies)
Discussion started by: marshmallow
2 Replies

2. Shell Programming and Scripting

Mailing files with, ls filtered with grep

Hi guys Im new to forum so please dont be hard to me if I make any mistakes :) I want to the following task: 1. I have a file lets say file1, which contains job names with numbers which have failed to start and .... I can sort that file into another to get only the Job numbers with... (3 Replies)
Discussion started by: kl1ngac1k
3 Replies

3. Shell Programming and Scripting

How to replace some content of a file and write with a new name

Hi I have a control file which looks like this LOAD DATA INFILE '/home/scott/XXX.dat' PRESERVE BLANKS ............. ............. how can i change the content of this file and replace the file in the second line with anothe file name and write it back with another name to the disk? ... (5 Replies)
Discussion started by: mwrg
5 Replies

4. Shell Programming and Scripting

split content and write to new record

Hi, Help required to split record value and write to new row. Input a~b~c~value in ('3','4','5')~test output a~b~c~3~test a~b~c~4~test a~b~c~5~test input a~b~c~value in ('3','4')~test output a~b~c~3~test a~b~c~4~test (8 Replies)
Discussion started by: Jairaj
8 Replies

5. Shell Programming and Scripting

How can I write the specific content in the file through shell script

Hello, I need to do one thing that my script creates the file touch release.SPLASH_12_03_00_RC01.txt Now I want to update that file with some content e.g splashbuild::SPLASH_12_17_00_RC02.zip Thanks (1 Reply)
Discussion started by: anuragpgtgerman
1 Replies

6. Shell Programming and Scripting

"Search for files in a file and write these files to another file which sould be in some other direc

Hi , Need to shell script to extracts files names and write those to another file in different directory. input file is inputfile.txt abc|1|bcd.dat 123 david123 123 rudy2345 124 tinku5634 abc|1|def.dat 123 jevid123 123 qwer2345 124 ghjlk5634 abc|1|pqr.txt 123 vbjnnjh435 123 jggdy876... (1 Reply)
Discussion started by: dssyadav
1 Replies

7. Shell Programming and Scripting

search for content in files. Name of files is in another file. Format as report.

Hi I have multiple files in a folder and one file which contains a list of files (one on each line). I was to search for a string only within these files and not the whole folder. I need the output to be in the form File1<tab>string instance 2<tab> string instance 2<tab>string instance 3... (6 Replies)
Discussion started by: pkabali
6 Replies

8. Shell Programming and Scripting

Import 2 columns from 8 .csv files into pandas df (side by side) and write a new csv

I have 8 .csv files with 16 columns and "n" rows with no Header. I want to parse each of these .csv and get column and put the data into a new.csv. Once this is done, the new.csv should have 16 columns (2 from each input.csv) and "n" rows. Now, I want to just take the average of Column from... (3 Replies)
Discussion started by: Zam_1234
3 Replies

9. Shell Programming and Scripting

Content should be filtered within brackets

Hello all, I have a string and would like to extract the content of the text within the brackets. Here is the string: Desc="file from to line" What I would like to have is the following: Filename="4009821_737498.out" FromLine=12965 ToLine=12355 Maybe I have to do this with... (6 Replies)
Discussion started by: API
6 Replies

10. Shell Programming and Scripting

Counting number of times content in columns occurs in other files

I need to figure out how many times a location (columns 1 and 2) is present within a group of files. I figured using a combination of 'while read' and 'grep' I could count the number of instances but its not working for me. cat file.txt | while read line do grep $line *08-new.txt | wc -l... (6 Replies)
Discussion started by: ncwxpanther
6 Replies

LEARN ABOUT DEBIAN

dpkg-www

DPKG-WWW(1)						      General Commands Manual						       DPKG-WWW(1)

NAME

       dpkg-www - program to remotely open a WWW Debian package browser

SYNOPSIS

       dpkg-www [-s|--stdout] [-h|--host host] [query]

DESCRIPTION

       dpkg-www is used to remotely control a WEB browser and open a dpkg URL on the local host from an interactive shell or script.

       If  the	command  is invoked while running under X-window the script will try to find an installed X browser to open the specified URL.	If
       not running under X it will try to use a text browser instead.

       If Netscape is found and a Netscape instance is already running it will be asked to open the dpkg URL on localhost with the optional  query
       supplied on the command line.  If there is no browser running, it will start automatically a new one.

       The  functionality  provided  by this program is identical to running a web browser with the -remote openURL(http://localhost/cgi-bin/dpkg)
       argument or opening the same URL from within the browser.

       dpkg-www-installer is an helper application which can configured in the WWW browser for	web  installation.  It	should	never  be  invoked
       directly by the user.

OPTIONS

       -s, --stdout
	      Redirect output to stdout. Requires one of the text browsers (lynx, lynx-ssl or links) installed.

       -h, --host host
	      Send the query to a remote host, where dpkg-www must be installed.

       query  Specifies  an  optional  package name, an absolute pathname or a query argument which is passed to the dpkg cgi-bin. See dpkg-www(8)
	      for more information about the use of the cgi.

FILES

       /etc/dpkg-www.conf

       ~/.dpkg-www
	      Configuration files for dpkg-www. It is not necessary for these files to exist, there are sensible defaults for everything, but  you
	      can specify your preferred www browser with the DPKG_WWW_BROWSER variable, for example: DPKG_WWW_BROWSER=mozilla

EXAMPLES

       dpkg-www
	      This would open a dpkg URL on localhost listing all the installed packages.

       dpkg-www bash
	      This would open a dpkg URL asking info on the bash package.

       dpkg-www -h pisolo bash
	      This would open a dpkg URL asking info on the bash package on host pisolo.

       dpkg-www 'dpkg*'
	      This would open a dpkg URL listing all packages matching dpkg*.

       dpkg-www /bin/bash
	      This would open a dpkg URL asking info on the package(s) owning the file /bin/bash .

       dpkg-www depends=svgalib
	      This would open a dpkg URL listing all packages depending on svgalib.

       dpkg-www --stdout depends=awk | grep ^ii
	      This would list on stdout all packages depending on awk and grep all lines of installed packages.

SEE ALSO

       dpkg(8), dpkg-www(8)

AUTHOR

       Massimo Dal Zotto <dz@debian.org>.
       Bugs should be reported via the normal Debian bug reporting system.

LICENCE

       dpkg-www is licensed under the GNU General Public License version 2.

								 September 1, 2004						       DPKG-WWW(1)
All times are GMT -4. The time now is 12:58 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy