find -name '*.txt' |
while read filename
do
awk -F"\t" -v name="$file"'
BEGIN {OFS="|"}
{print $2,$14,$15,name}
' $filename > output.txt
done
Your data sample is useless try to copy/paste again and use [code] tags not [table] tags !
From your spinet
Code:
for filename in *.txt # you don't need to find anything special and you are in current directory anyway
do
awk -F"\t" ' # awk have the internal FILENAME variable(read the manual)
BEGIN {OFS="|"} {print $2,$14,$15,FILENAME}
' $filename > output.txt
done
Not tested but should work if that's what you want.
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 (0 Replies)
Hi guys,
say I have a few files in a directory (58 text files or somthing)
each one contains mulitple strings that I wish to replace with other strings
so in these 58 files I'm looking for say the following strings:
JAM (replace with BUTTER)
BREAD (replace with CRACKER)
SCOOP (replace... (19 Replies)
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:... (8 Replies)
Hi,
I'd like to process multiple files. For example:
file1.txt
file2.txt
file3.txt
Each file contains several lines of data. I want to extract a piece of data and output it to a new file.
file1.txt ----> newfile1.txt
file2.txt ----> newfile2.txt
file3.txt ----> newfile3.txt
Here is... (3 Replies)
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 Replies)
Hi,
I have a directory /home/datasets/ which contains a bunch (720) of subdirectories called hour_1/ hour_2/ etc..etc.. in each of these there is a single text file called (hour_1.txt in hour_1/ , hour_2.txt for hour_2/ etc..etc..) and i would like to do some text processing in them.
Each of... (20 Replies)
I have an issue with some fortran include files.
I have the following src directory structure,
trunk/src/client_main
trunk/src/client_models
trunk/src/server
The make file is at trunk/makefile.
In /src/client_main there are some included dependencies,
COMMON.BLK
PARAM.DAT... (0 Replies)
I need to extract the data from oracle table and written the below code.
But it is not working.There is some problem with the query and output is shown is No rows selected" . If I run the same query from sql developer there is my required output.
And if I run the shell script with simple sql... (7 Replies)
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... (14 Replies)
Hi,
Is there any way to do a cat * where it shows the name of each file in the process? Similar to what more does below?
$ more ?.sql
::::::::::::::
1.sql
::::::::::::::
set linesize 200
select db_unique_name,
cast(
from_tz(
cast(... (5 Replies)
Discussion started by: newbie_01
5 Replies
LEARN ABOUT DEBIAN
gopen
GOPEN(1) GNUstep System Manual GOPEN(1)NAME
gopen - open files
SYNOPSIS
gopen [-a application] [-o] [-p] [-NXHost hostname] [filename]
DESCRIPTION
The gopen command allows you open a file (or directory) as if you had double clicked the object's icon.
It is possible to specify one or more filenames which are interpreted relative to the current working directory.
By default, gopen will open filename with the application currently assigned to the file's extension. But by specifing the -a flag on the
command line you can tell gopen to open the file with another application.
You can also directly print a file without ( -p ) or with ( -p -o ) opening it.
As with most other GNUstep software, it is easily possible to attach the process to a remote window server using the -NXHost flag.
OPTIONS -a application
use application to open filename
-o open filename (may be used in conjunction with -p ).
-p print filename instead of opening.
-NXHost hostname
attach to remote window server on hostname
EXAMPLES
Open all files with a .txt extension in the current directory:
gopen *.txt
To open a source file in CodeEditor (instead of the current default application), type:
gopen -a CodeEditor MySourceFile.m
To print the .plan file in your home folder, use the -p flag:
gopen -p ~/.plan
BUGS
Using the -a application argument, gopen allows you to open any kind of file with any application you want. This does, however, not work
with applications employing the NSDocument architecture as they will only receive filenames whose types the application has registered. To
circumvent this limitation, applications may advertise their ability to open all kinds of files through the "*" filetype. When gopen is
used with only the -a application argument but no filename
present, the application is simply launched without opening a specific file.
SEE ALSO GNUstep(7), openapp(1)HISTORY
gopen was written November 2001.
This manual page was first written July 2003.
AUTHORS
gopen was written by Gregory Casamento <greg_casamento@yahoo.com>.
This man page was written by Martin Brecher <martin@mb-itconsulting.com>.
GNUstep August 2003 GOPEN(1)