12-09-2011
Looks like you are mixing up shell with awk.
Shell does not know about $90. In awk this would be field $90, yes.
On the other side defining a shell variable which's name is consisting only of numeric characters does not work, so you are definetly mixing up things.
Also the function length() is an awk function.
I don't understand if you already extracted field 90 and it has a lot of spaces in it so it produces a length of 158 instead of 3 or if you have a complete line where field 90 is not even extracted yet?
Maybe post the line using code tags and tell if you only want to measure it's length or also get it's output printed, thanks.
This User Gave Thanks to zaxxon For This Post:
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi!
I'm using SunOS 5.7 w/ Bash 2.01.
Currently, I'm working on a script that will make it possible to find textfiles which match certain criteria. While I write this message, I had some brainfarts, found the answer myself :D and the question I had in mind is now no longer the question I... (3 Replies)
Discussion started by: indo1144
3 Replies
2. Shell Programming and Scripting
Hi all, I'm a newbie to the Linux world and I got a couple of shell script questions:
(1) How do combine two variables and make it equal to a third variable? For example, I got a variable $A=FirstName, $B=LastName, and I want to combine the variable into one variable so when you echo the final... (4 Replies)
Discussion started by: mikey20
4 Replies
3. Shell Programming and Scripting
When formatting a script let's say for instance the following:
case ${choice} in
1)
vi ${tmp1}.tmp
# overwrite the tmp1 var with any user changes
cp ${tmp1}.tmp ${tmp1}
;;
... (2 Replies)
Discussion started by: llsmr777
2 Replies
4. Shell Programming and Scripting
I want my program to replace tabs with spaces.1tab=4spaces.When i write aa(tab)aaa(tab)(tab)a(tab) it must show me aaxxaaaxxxxxaxxx. I think that my program works corectly but when a write aaa(tab)a it must show aaaxa but it is aaaxxxxxa.Please for help!!! That is my code:
#include <stdio.h>
... (3 Replies)
Discussion started by: marto1914
3 Replies
5. Shell Programming and Scripting
I am getting a value from a csv file using CUT command, however the command extracting the records with trailing spaces. I am using the result into a sql session to fetch data, because of the trailing spaces the sql session is unable to fetch any data.
Please let me know, how to remove this... (2 Replies)
Discussion started by: mady135
2 Replies
6. Shell Programming and Scripting
hi buddies;
i have a file.txt:
Note: All the seperators are SPACE.
192.168.1.1
ParameterObject=1 Speech 1
ParameterObject=2 Speech 1
192.168.1.1
ParamFunction=1 UserID 1 (DEACTIVATED)
Sector=1,Device=2,Unit=3 DeviceId 1
192.168.1.1
FeederCable=2B ... (18 Replies)
Discussion started by: gc_sw
18 Replies
7. Shell Programming and Scripting
Hi, wondering if it's been asked before but didn't find matches from google. Basically I have this line:
myvar=$(echo -e "a\tb")
Now somehow the '\t' from the echo output gets replaced with white space and then stored in $myvar.
It creates a problem for me later to use tab as delimiter to do... (2 Replies)
Discussion started by: birddie
2 Replies
8. Shell Programming and Scripting
Hi All,
I wanted to know is there any way we can remove white spaces/tabs before & after some pattern { eg. before & after "," }.
Please find below sample data below,
Sat Jul 23 16:10:03 EDT 2011 , 12345678 , PROD , xyz_2345677 , testuuyt , ... (3 Replies)
Discussion started by: gr8_usk
3 Replies
9. Shell Programming and Scripting
I have a variable
I want to remove the spaces in between.
The output should be
How can this be done
Any help will be appreciated. Thanks in advance (1 Reply)
Discussion started by: irudayaraj
1 Replies
10. Shell Programming and Scripting
Hi
I have variable named tablename. The value to tablename variable has leading and trailing white spaces. How to remove the leading and training white spaces and write the value of the tablename without space to a file using shell script. ( for e.g. tablename= yyy )
INPUT
... (10 Replies)
Discussion started by: pottic
10 Replies
JOIN(1) General Commands Manual JOIN(1)
NAME
join - relational database operator
SYNOPSIS
join [ options ] file1 file2
DESCRIPTION
Join forms, on the standard output, a join of the two relations specified by the lines of file1 and file2. If file1 is `-', the standard
input is used.
File1 and file2 must be sorted in increasing ASCII collating sequence on the fields on which they are to be joined, normally the first in
each line.
There is one line in the output for each pair of lines in file1 and file2 that have identical join fields. The output line normally con-
sists of the common field, then the rest of the line from file1, then the rest of the line from file2.
Fields are normally separated by blank, tab or newline. In this case, multiple separators count as one, and leading separators are dis-
carded.
These options are recognized:
-an In addition to the normal output, produce a line for each unpairable line in file n, where n is 1 or 2.
-e s Replace empty output fields by string s.
-jn m Join on the mth field of file n. If n is missing, use the mth field in each file.
-o list
Each output line comprises the fields specifed in list, each element of which has the form n.m, where n is a file number and m is a
field number.
-tc Use character c as a separator (tab character). Every appearance of c in a line is significant.
SEE ALSO
sort(1), comm(1), awk(1)
BUGS
With default field separation, the collating sequence is that of sort -b; with -t, the sequence is that of a plain sort.
The conventions of join, sort, comm, uniq, look and awk(1) are wildly incongruous.
JOIN(1)