05-08-2009
I have tried cut, paste options but that is not what I want to use....If I use the following command
awk '{print $1,$3,$6,$4,$5,"FILE1" > "output1.file"}' inputfile I don't get the desired results.....
Input file:
0104100400,C,41.26,43.33,45.39,04/APR/2009,2009,02,MAR,LPF 3: % YTD(Main Exchange),03/APR/2010
Output (desired):
0104100400,41.26,04/APR/2009,43.33,45.39,FILE1
Output (actual with this awk command):
0104100400,C,41.26,43.33,45.39,04/APR/2009,2009,02,MAR,LPF % YTD(Main Exchange),03/APR/2010 FILE1
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Can anyone tell me how to remove a portion of a large file to smaller ones? What I have is a large file that was created becasue several similar files were joined together. Each individual file starts with MSG_HEAD. I want to take everything from MSG_HEAD up to were it says MSG_HEAD again and... (13 Replies)
Discussion started by: methos
13 Replies
2. Programming
hi i would like to know whether i can delete a part of a file in C
for eg. if my file contained
1234567890
and i want to delete
456
so that it becomes
1237890
is there a way i can do this.
well, one way i can achieve this is by creating a new file, copy whatever i want, then delete the... (2 Replies)
Discussion started by: sameersbn
2 Replies
3. UNIX for Dummies Questions & Answers
Hi,
I have a little problem. I am having a file with pattern like :
asdf;ffgg;dfjfj;djdfjf;nnjj;djd;ssj;
I just want to print the portion from last ";" upto the immediate previous ";". There are several ";" in my line.
Please help me out...
Thnx in advance (8 Replies)
Discussion started by: vanand420
8 Replies
4. Shell Programming and Scripting
Well the title is not too good, so I will explain.
I need to move (rename) files using a simple AIX script.
???file1.txt
???file2.txt
???file1a.txt
???file2a.txt
to be:
???renamedfile1'date'.txt
???renamedfile2'date'.txt
???renamedfile1a'date'.txt
???renamedfile2a'date'.txt
... (4 Replies)
Discussion started by: grimace15
4 Replies
5. Shell Programming and Scripting
Dear Friends,
Here I am with another difficulty. I have a flat file from which I wanna grep following pattern.
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Statement Date : Blah blah
Blah blah
Blah blah
Blah blah... (1 Reply)
Discussion started by: anushree.a
1 Replies
6. Shell Programming and Scripting
Need to sort a portion of a file in a Alphabetical Order.
Example : The user adam is not sorted and the user should get sorted. I don't want the complete file to get sorted.
Currently All_users.txt contains the following lines.
##############
# ARS USERS
##############
mike, Mike... (6 Replies)
Discussion started by: evrurs
6 Replies
7. Shell Programming and Scripting
Hi,
I have some files as below.
Temp6001_5025.cpp
Temp6002_5025.cpp
Temp6003_5025.cpp
Temp6004_5025.cpp
Temp6005_5025.cpp
Temp6006_5025.cpp
Temp6007_5025.cpp
.
.
Temp6100_5025.cpp
i want to replace 5025 to 5026 in all files and the result should be
Temp6001_5026.cpp
.
.... (3 Replies)
Discussion started by: lathigara
3 Replies
8. UNIX for Dummies Questions & Answers
Hi ladies and gentleman.. I have two text file with me. I need to replace one of the file content to another file if one both files have a matching pattern.
Example:
text1.txt:
ABCD 1234567,HELLO_WORLDA,HELLO_WORLDB
DCBA 3456789,HELLO_WORLDE,HELLO_WORLDF
text2.txt:
XXXX,ABCD... (25 Replies)
Discussion started by: bananamen
25 Replies
9. Shell Programming and Scripting
Hi all,
What I would like to achieve is to batch change the code below in every pdf in a given directory (each pdf is uncompressed so that can be easily edited).
An example of the javascript code:
if (this.hostContainer) { try { this.hostContainer.postMessage(pp_216', 15259]);... (3 Replies)
Discussion started by: menteith
3 Replies
10. Shell Programming and Scripting
In the below bash I am trying to rename eachof the 3 text files in /home/cmccabe/Desktop/percent by matching the numerical portion of each file to lines 3,4, or 5 in /home/cmccabe/Desktop/analysis.txt. There will always be a match between the files. When a match is found each text file in... (2 Replies)
Discussion started by: cmccabe
2 Replies
JOIN(1) FSF JOIN(1)
NAME
join - join lines of two files on a common field
SYNOPSIS
join [OPTION]... FILE1 FILE2
DESCRIPTION
For each pair of input lines with identical join fields, write a line to standard output. The default join field is the first, delimited
by whitespace. When FILE1 or FILE2 (not both) is -, read standard input.
-a SIDE
print unpairable lines coming from file SIDE
-e EMPTY
replace missing input fields with EMPTY
-i, --ignore-case ignore differences in case when comparing fields
-j FIELD
(obsolescent) equivalent to `-1 FIELD -2 FIELD'
-j1 FIELD
(obsolescent) equivalent to `-1 FIELD'
-j2 FIELD
(obsolescent) equivalent to `-2 FIELD'
-o FORMAT
obey FORMAT while constructing output line
-t CHAR
use CHAR as input and output field separator
-v SIDE
like -a SIDE, but suppress joined output lines
-1 FIELD
join on this FIELD of file 1
-2 FIELD
join on this FIELD of file 2
--help display this help and exit
--version
output version information and exit
Unless -t CHAR is given, leading blanks separate fields and are ignored, else fields are separated by CHAR. Any FIELD is a field number
counted from 1. FORMAT is one or more comma or blank separated specifications, each being `SIDE.FIELD' or `0'. Default FORMAT outputs the
join field, the remaining fields from FILE1, the remaining fields from FILE2, all separated by CHAR.
AUTHOR
Written by Mike Haertel.
REPORTING BUGS
Report bugs to <bug-coreutils@gnu.org>.
COPYRIGHT
Copyright (C) 2002 Free Software Foundation, Inc.
This is free software; see the source for copying conditions. There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICU-
LAR PURPOSE.
SEE ALSO
The full documentation for join is maintained as a Texinfo manual. If the info and join programs are properly installed at your site, the
command
info join
should give you access to the complete manual.
join (coreutils) 4.5.3 February 2003 JOIN(1)