10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
I have a requirement to format the data in a new order. Here is my source format :
ppp ***Wed Dec 16 10:32:30 GMT 2015
header1 header2 header3 header4 header5
server1 0.00 0.02 0.07 0.98
server2 0.01 0.00 0.08 0.79
server3 0.05 0.82 0.77 0.86
... (18 Replies)
Discussion started by: john_prince
18 Replies
2. Shell Programming and Scripting
Hi,
I need help to convert rows in input file into a table.
inputfile
192.98.1 192.98.192.98.17 VVC family Zorro 10
192.98.1 192.98.192.98.17 VVC family Ace 1
192.98.1 192.98.192.98.17 VVC family ... (4 Replies)
Discussion started by: redse171
4 Replies
3. Shell Programming and Scripting
Convert Single column to multiple rows
file a.txt contains data like below
Server=abc
Run=1
Tables=10
Sessions=16
Time=380
Jobs=5
Server=abc
Run=2
Tables=15
Sessions=16
Time=400
Jobs=5
Server=abc
Run=3
Tables=20
Sessions=16
Time=450 (5 Replies)
Discussion started by: sol_nov
5 Replies
4. Shell Programming and Scripting
Hi Experts,
I have a requirement to convert rows into columns.
For e.g.
Input File:
Output File should be like
Appreciate if you could suggest code snippet(may be awk) for above requirement...
Thanks in Advance for your help... (3 Replies)
Discussion started by: sai_2507
3 Replies
5. Shell Programming and Scripting
I have this file
103,7243534512111,NiaC1-02
105,720412845543550,NiaC2-00
105,720439254543351,NiaC200
105,720445724354315,Nia100
105,72044770454398,Nia100
105,720484154334546,Nia616
i want in this format
insert into aildump values(103,'7243534512111','NiaC1-02');
I'm able to... (3 Replies)
Discussion started by: nikhil jain
3 Replies
6. Shell Programming and Scripting
Dear All,
I have a data file input.csv like below. (Only five column shown here for example.)
Data1,StepNo,Data2,Data3,Data4
2,1,3,4,5
3,1,5,6,7
3,2,4,5,6
5,3,5,5,6
From this I want the below output
Data1,StepNo,Data2,Data3,Data4
2,1,3,4,5
3,1,5,6,7
where the second column... (4 Replies)
Discussion started by: ks_reddy
4 Replies
7. Shell Programming and Scripting
Hi I have the text file like this
"A"
"AA Info"
"AA Text"
"AAA"
"ABC"
"ABC Info"
"ABC Tech"
"AGH"
"SYN"
"SYMBony"
"SYN BEREN"
Like about 2000 lines
Output would be in Column with groups like following
"A"
"AA Info", "AA Text"
"AAA"
"ABC","ABC Info","ABC Tech" (0 Replies)
Discussion started by: selvanraj
0 Replies
8. Shell Programming and Scripting
Hi,
I have a file with below contents.
Heading1 Heading2 Heading3 Heading4
Value1 Value2 Value3 Value4
The file has only 2 rows and is tab separated
The desired output is :
Heading1 Value1
Heading2 Value2
Heading3 Value3
Heading4 Value4
CAn you please help? (5 Replies)
Discussion started by: kaponeh
5 Replies
9. Shell Programming and Scripting
Hi Friends,
I have a log file as below
siteid = HYD
spc = 100
rset = RS_D_M
siteid = DEL
spc = 200
rset = RS_K_L
siteid = DEL2
spc = 210
rset = RS_D_M
Now I need a output like column wise as below.
siteid SPC rset
HYD 100 RS_D_M (2 Replies)
Discussion started by: suresh3566
2 Replies
10. Shell Programming and Scripting
if u have a data
2 4 6 8 5 4 4 5 6
then result shud be like
2
4
6
7
5
4
4
5
6 (3 Replies)
Discussion started by: cdfd123
3 Replies
RS(1) BSD General Commands Manual RS(1)
NAME
rs -- reshape a data array
SYNOPSIS
rs [-CcSs [x]] [-GgKkw N] [-EeHhjmnTty] [rows [cols]]
DESCRIPTION
rs reads the standard input, interpreting each line as a row of blank-separated entries in an array, transforms the array according to the
options, and writes it on the standard output. With no arguments it transforms stream input into a columnar format convenient for terminal
viewing.
The shape of the input array is deduced from the number of lines and the number of columns on the first line. If that shape is inconvenient,
a more useful one might be obtained by skipping some of the input with the -k option. Other options control interpretation of the input col-
umns.
The shape of the output array is influenced by the rows and cols specifications, which should be positive integers. If only one of them is a
positive integer, rs computes a value for the other which will accommodate all of the data. When necessary, missing data are supplied in a
manner specified by the options and surplus data are deleted. There are options to control presentation of the output columns, including
transposition of the rows and columns.
The options are described below.
-C [x] Output columns are delimited by the single character x. A missing x is taken to be '^I'.
-c [x] Input columns are delimited by the single character x. A missing x is taken to be '^I'.
-e Consider each line of input as an array entry.
-G N The gutter width (inter-column space) has N percent of the maximum column width added to it.
-g N The gutter width (inter-column space), normally 2, is taken to be N.
-H Like -h, but also print the length of each line.
-h Print the shape of the input array and do nothing else. The shape is just the number of lines and the number of entries on the
first line.
-j Right adjust entries within columns.
-K N Like -k, but print the ignored lines.
-k N Ignore the first N lines of input.
-m Do not trim excess delimiters from the ends of the output array.
-n On lines having fewer entries than the first line, use null entries to pad out the line. Normally, missing entries are taken
from the next line of input.
-S [x] Like -C, but padded strings of x are delimiters.
-s [x] Like -c, but maximal strings of x are delimiters.
-T Print the pure transpose of the input, ignoring any rows or cols specification.
-t Fill in the rows of the output array using the columns of the input array, that is, transpose the input while honoring any rows
and cols specifications.
-w N The width of the display, normally 80, is taken to be the positive integer N.
-y If there are too few entries to make up the output dimensions, pad the output by recycling the input from the beginning. Nor-
mally, the output is padded with blanks.
-z Adapt column widths to fit the largest entries appearing in them.
With no arguments, rs transposes its input, and assumes one array entry per input line unless the first non-ignored line is longer than the
display width. Option letters which take numerical arguments interpret a missing number as zero unless otherwise indicated.
EXAMPLES
rs can be used as a filter to convert the stream output of certain programs (e.g., spell(1), du(1), file(1), look(1), nm(1), who(1), and
wc(1)) into a convenient ``window'' format, as in
who | rs
This function has been incorporated into the ls(1) program, though for most programs with similar output rs suffices.
To convert stream input into vector output and back again, use
rs 1 0 | rs 0 1
A 10 by 10 array of random numbers from 1 to 100 and its transpose can be generated with
jot -r 100 | rs 10 10 | tee array | rs -T > tarray
In the editor vi(1), a file consisting of a multi-line vector with 9 elements per line can undergo insertions and deletions, and then be
neatly reshaped into 9 columns with
:1,$!rs 0 9
Finally, to sort a database by the first line of each 4-line field, try
rs -eC 0 4 | sort | rs -c 0 1
SEE ALSO
jot(1), pr(1), sort(1), vi(1)
BUGS
Handles only two dimensional arrays.
The algorithm currently reads the whole file into memory, so files that do not fit in memory will not be reshaped.
Fields cannot be defined yet on character positions.
Re-ordering of columns is not yet possible.
There are too many options.
BSD
December 18, 2001 BSD