I am often given log files at work in .csv format to work with, normally extracting various fields. I then have to figure out the number of each field so that I can extract that field with cut or awk. Normally I just manually count the fields, based on the field separator. I would like to be able to take a line from the file and list the contents of each field along with the number of a field. Thus having the line of a file, such as:
I would like to see the output as:
I can then quickly see the columns that I need to extract.
I am aware of the "column" command, but often the files I have contain too many columns for this command to work.
Does any one know how to get a recursive directory listing in long format (showing owner, group, permission etc) without listing the files contained in the directories.
The following command also shows the files but I only want to see the directories.
ls -lrtR * (4 Replies)
I am brand new to Unix. This is probably simple, but how do you list the contents of a shared library? I need to see which functions exist in it.
Many thanks. (1 Reply)
How would I find three different fields in a data file such as first name, last name, credit card number in a particular file?
Thanks in advance for your help (3 Replies)
Hello guys,
I am having a requirement,
I am having three file m1,m2,m3 having some contents. I want to list last 20 lines of m1,m2 and m3 all together on the terminal.
I used tail -20 m1 m2 m3,
but it is showing error,
tail: option used in invalid context -- 2
Can u help me... (2 Replies)
Hi fellows,
Can you please share any command with which I can list down the file names inside a tar.gz file.
I have tried with these possibilities but in vain.
bash-3.00$ tar -ztvf file.tar.gz
tar: z: unknown function modifier
bash-3.00$ tar ztvf file.tar.gz
tar: z: unknown function... (1 Reply)
Hi All,
Could you please help to resolve my following issues:
Problem Description:
Suppose my user name is "MI90".
i.e. $USER = MI90
when i run below command, i get all the processes running on the system containing name MQ.
ps -ef | grep MQ
But sometimes it lists... (8 Replies)
Hi one of the output of the command is as below
# sed -n "/CCM-ResourceHealthCheck:/,/---------/{/CCM-ResourceHealthCheck:/d;/---------/d;p;}" Automation.OutputZ$zoneCounter | sed 's/$/<br>/'
Resource List : <br>
*************************** 1. row ***************************<br>
... (2 Replies)
Hi,
We are taking our filesystem backup having size of 1.3 TB on LTO5 catridges using the following command
find * -print|backup -ivf '/dev/rmt0' '-U'
i.e backup byname and it took about 6.5 Hours to complete When we are listing same tape contents using the following command
restore... (1 Reply)
Hi All,
I would like to know couple of ways to list the content available in tar and gzipped file without extracting.
i.e., I would like to display the contents of test.tar.gz without extracting.
Note :: please suggest a command other that tar -ztvf (9 Replies)
Hi All
I have a file which contains the timestamp of the log and a message and I want to implement a polling mechanism, where this log file is pooled every 2 minutes and list the errors in the file. I want to list down the errors only after the timestamp in the file is more than the current... (2 Replies)
Discussion started by: infyanurag
2 Replies
LEARN ABOUT V7
join
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)