I would like some help with the above awk command.
I am trying to use the join command to join two files, no luck.
I need to put the second column from file2.txt into each matching field of file1.txt.
It works OK up to the value of 1000 of the matching column (1at column in both files), then nothing.
Any help would be appreciated,
thanks
Sid
file1.txt
file2.txt
I only get
I need matching for when the values of column 1 are higher...
using
gives me
but I need all the instances of
etc.
thanks
Sid
Moderator's Comments:
edit by bakunin: first off, do not hijack other threads. You have your own problem - open your own thread! We happen to have spare unused threads in abundance and you can use one of them free of any extra charge.
Second: Please view this code tag video for how to use code tags when posting code and data.
I have moved this post to its own thread. Thanks for your consideration.
Greetings, all. I've got a project that requires I join two data files together, then do some processing and output. Everything must be done in a shell script, using standard unix tools. The files look like the following:
File_1
Layout:
Acct#,Subacct#,Descrip
Sample:
... (3 Replies)
The script checks for free space stats on Oracle. If there are any tablespaces with more than 85% usage it prints the details of the tablespace. If all the tablespaces have more than 15% free space, then "All tablespaces have more than 15 pct free space" must be printed on the screen.
When I run... (2 Replies)
I am trying to find only those entries where 7018 and another number appear in the end of the line.
7018 2828 1423 2351
7018 2828 14887
2828 7018 1222
123 7018 1487
I am looking for a way to generate only the last two lines. I was trying to do just "grep '7018{1,5}" but it does not... (5 Replies)
Hi,
I am trying to parse regular XML file where I have to reduce number of decimal points in some xml elements. I am using following AWK command to achive that :
#!/bin/ksh
EDITCMD='BEGIN { FS = ""; OFS=FS }
{
if ( $3 ~ "*\\.*" && length(substr($3,1+index($3,"."))) == 15 ) {... (4 Replies)
I have two comma separated files.
I want to join those filesa nd put the result in separate file.
smaple data are:
file1:
A1,1,100
A2,1,200
B1,2,100
B2,2,200
file2
1,50
1,25
1,25
1,100
1,100
2,50
2,50 (10 Replies)
Hi,
I have about 20 tab delimited text files that have non sequential numbering such as:
UCD2.summary.txt
UCD45.summary.txt
UCD56.summery.txt
The first column of each file has the same number of lines and content. The next 2 column have data points:
i.e UCD2.summary.txt:
a 8.9 ... (8 Replies)
Why when I use this command do I get "E123"?
echo NCE123 | sed -n 's/\(.*\)\(\{1,\}\{1,5\}\)\(.*\)/\2/p'
But when I used this command, I get NCE123?
echo NCE123 | sed -n 's/\(.*\)\(\{3\}\{1,5\}\)\(.*\)/\2/p'
I thought \{1,\} would mean any number of characters and \{1,5\ would mean 1-5... (1 Reply)
Hi All,
Thanks for your help in advanced.
Could you please kindly help on why my SETUID does not work?
create a file, only root can read write it
/tmp>ls -l a.log
-rw------- 1 root root 3 Nov 12 18:57 a.log
create a script under root with SETUID
/tmp>ls -l a.sh
-rwsr-sr-x 1 root... (3 Replies)
Repeat this text in a file named notes.txt and run the script
Before bash is a good language a blank line appears
Also, the following notes are displayed incorrectly
What is bad?
==================================
Title : Note 1
==================================
Category: Computer
Date... (3 Replies)