The difference between end number in the early row and the start number in the next
Hi Power User,
I'm trying to compute this kind of text file format:
file1:
jakarta 100 150
jakarta 170 210
beijing 220 250
beijing 260 280
beijing 290 320
new_york 330 350
new_york 370 420
tokyo 430 470
tokyo 480 485
seoul 490 540
seoul 570 590
seoul 640 680
seoul 730 750
singapur 780 830
singapur 860 940
. . .
. . .
. . .
p b e
The meaning of the dots that goes away until 'p', 'b', and 'e' are the marker that the flow those data still goes on until that point. The desired output is like this:
file2:
jakarta 170 150
beijing 260 250
beijing 290 280
new_york 370 350
tokyo 480 470
seoul 570 540
seoul 640 590
seoul 730 680
singapur 860 830
. . .
. . .
. . .
p b e
The explanation, the desired data is the difference between the end number in the town in the early row and the start number in the town in the next row. The numerical difference between different cities is not asked.
Hi
I've file1 as:
after I read all rows with awk, I need to change some of them.
I mean, for example if the last row is zero then change row number 4 in zero too.
So I'd like to refers each row as a vector and change its value accordly some conditions. I know that NR keep just the "current"... (2 Replies)
Hello People,
I have the following contents in an XML file
...........
...........
..........
...........
<Details = "Sample Details">
<Name>Bob</Name>
<Age>34</Age>
<Address>CA</Address>
<ContactNumber>1234</ContactNumber>
</Details>
...........
.............
.............. (4 Replies)
I have a two files containing numbers like below. First one contains one number on each line, the other is a table of numbers, each separated by a space. There are the same number of lines in each file.
I want to take each number in the row of the table and find the difference from the... (12 Replies)
I have a file with contents similar to this.
abcd
1234
4567
7666
jdjdjd
89289
9382
92
jksdj
9823
298
I want to write a shell script which count the number of lines that start with the number (disregard the lines starting with alphabets) (1 Reply)
Hi experts a have a very large file and I need to add two columns: the first one numbering the incidence of records and the another with the total count
The input file:
21 2341 A
21 2341 A
21 2341 A
21 2341 C
21 2341 C
21 2341 C
21 2341 C
21 4567 A
21 4567 A
21 4567 C
... (6 Replies)
Dear All,
I am new to UNIX . Please tell me how to retreive row number from the file.
In AS/400 we can retreive RRN(Relative record number ) from the file, In same way what is the option to take relative record number from the file in UNIX.
It may be very easy query, but still I need ur... (9 Replies)
I have a fixed length file and I want to find out row number along with row length.
I have a program that give me the line length if it satisfy the condition; but i would like to add row number as well?
How do I do that?
while IFS= read -r line; do
if ; then
echo ${line}
echo... (8 Replies)
Hi.
How can we print those rows of file2 which are mentioned in file1. first character of file1 is a row number.. for eg
file1
1:abc
3:ghi
6:pqr
file2
a abc
b def
c ghi
d jkl
e mno
f pqr
... (6 Replies)
I have a file which looks something as following, I would like to split to several files, The start and end of each file is 'FILE' and end with 'ASCII... ' .
At the same time for each file in the first column add 100 and also second column add 100 the rest of the column as it is , see example of... (2 Replies)
Discussion started by: tk2000
2 Replies
LEARN ABOUT LINUX
shtool-table
SHTOOL-TABLE.TMP(1) GNU Portable Shell Tool SHTOOL-TABLE.TMP(1)NAME
shtool-table - GNU shtool pretty-print a field-separated list
SYNOPSIS
shtool table [-F|--field-sep sep] [-w|--width width] [-c|--columns cols] [-s|--strip strip] strsepstr...
DESCRIPTION
This pretty-prints a list of strings as a table.
OPTIONS
The following command line options are available.
-F, --field-sep sep
Separate columns using sep. Default is ":".
-w, --width width
Width of each column. Default is 15 characters.
-c, --columns cols
Number of columns. Default is 3.
-s, --strip strip
Strip off any characters past strip. Default is 79.
EXAMPLE
# shell script
shtool table -F , -w 5 -c 4 "1,2,3,4,5,6,7,8,9,10,11,12"
HISTORY
The GNU shtool table command was originally written by Ralf S. Engelschall <rse@engelschall.com> in 1999 for GNU shtool.
SEE ALSO shtool(1), tr(1), fmt(1), sh(1), awk(1), sed(1).
18-Jul-2008 shtool 2.0.8 SHTOOL-TABLE.TMP(1)