Using AWK: Extract data from multiple files and output to multiple new files Post: 302461683

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

extract multiple cloumns from multiple files; skip rows and include filenames; awk

Hello, I am trying to write a bash shell script that does the following: 1.Finds all *.txt files within my directory of interest 2. reads each of the files (25 files) one by one (tab-delimited format and have the same data format) 3. skips the first 10 rows of the file 4. extracts and...

2. Shell Programming and Scripting

need help with post:extract multiple columns from multiple files

hello, I will would be grateful if anyone can help me reply to my post extract multiple cloumns from multiple files; skip rows and include filenames; awk Please see this thread. Thanks manishabh

3. UNIX for Dummies Questions & Answers

AWK, extract data from multiple files

Hi, I'm using AWK to try to extract data from multiple files (*.txt). The script should look for a flag that occurs at a specific position in each file and it should return the data to the right of that flag. I should end up with one line for each file, each containing 3 columns:...

4. UNIX for Dummies Questions & Answers

awk, extract last line of multiple files

Hi, I have a directory full of *.txt files. I would like to print the last line of every file to screen. I know you can use FNR for printing the first line of each file, but how do I access the last line of each file? This code doesn't work, it only prints the last line of the last file:BEGIN...

5. UNIX for Dummies Questions & Answers

Use awk to pipe output from one file into multiple files

Hi All. Thanks for your help in advance. I have a requirement to examine the number of delimiters in each record of a file. If the record has the expected number of delimiters it should be passed into a 'good' file. If it does not, the record should be passed into a 'bad' file. I have been able...

6. Shell Programming and Scripting

awk, multiple files input and multiple files output

Hi! I'm new in awk and I need some help. I have a folder with a lot of files and I need that awk do something in each file and print a new file with the output. The input file name should be modified when I print the outpu files. Thanks in advance for help! :-) ciao

7. UNIX for Dummies Questions & Answers

Extract common data out of multiple files

I am trying to extract common list of Organisms from different files For example I took 3 files and showed expected result. In real I have more than 1000 files. I am aware about the useful use of awk and grep but unaware in depth so need guidance regarding it. I want to use awk/ grep/ cut/...

8. Shell Programming and Scripting

Extract data in tabular format from multiple files

Hi, I have directory with multiple files from which i need to extract portion of specif lines and insert it in a new file, the new file will contain a separate columns for each file data. Example: I need to extract Value_1 & Value_3 from all files and insert in output file as below: ...

9. Shell Programming and Scripting

Create Multiple UNIX Files for Multiple SQL Rows output

Dear All, I am trying to write a Unix Script which fires a sql query. The output of the sql query gives multiple rows. Each row should be saved in a separate Unix File. The number of rows of sql output can be variable. I am able save all the rows in one file but in separate files. Any...

10. Shell Programming and Scripting

Grep strings on multiple files and output to multiple files

Hi All, I want to use egrep on multiple files and the results should be output to multiple files. I am using the below code in my shell script(working in Ksh shell). However with this code I am not attaining the desired results. #!/bin/ksh ( a="/path/file1" b="path/file2" for file in...

LEARN ABOUT V7

aha

aha(1)								 Ansi HTML Adapter							    aha(1)

NAME

	aha - Ansi HTML Adapter

SYNOPSIS

       aha [options] [-f datei]

DESCRIPTION

       aha takes SGR-colored Input and prints W3C conform HTML-Code.
       aha reads the Input from a file or stdin and writes HTML-Code to stdout.

OPTIONS

       --help , -h , -?
	      A help like this

       --black , -b
	      Black Background and white "standard color"

       --pink , -p
	      Pink Background

       --iso X , -i X
	      Uses ISO 8859-X instead of utf-8. X must be 1..16

       --title X , -t X
	      Gives the html output the title

       --line-fix , -l
	      Uses a fix for inputs using control sequences to change the cursor position like htop. It's a hot fix, it may not work with any pro-
	      gram like htop. (See EXAMPLE)

EXAMPLE

       aha --help | aha --black --title "the awesome aha help"> aha-help.htm
	      Creates an HTML file with the help of aha with black background

       colordiff oldfile.c newfile.c | aha > colordiff.htm
	      Creates an HTML file with a colorful diff-output of two files "oldfile.c" and "newfile.c" with white background

       ls --color=always | aha --pink > ls.htm
	      Creates an HTML file with a colorful ls-output with pink background.

       echo a | htop | aha --black --line-fix > htop.htm
	      Creates an HTML file with the output of htop. You have to use --line-fix due the other new-line-commands htop uses.

AUTHOR

       Copyleft Alexander Matthes aka Ziz 2011
       zizsdl@googlemail.com

SEE ALSO

       http://ziz.delphigl.com/tool_aha.php

								  August 31, 2011							    aha(1)