07-26-2017
As i said i tried to create a script basing on some simillar posted threads but i failed, and i have to learn more to be able to create a such script.
Thanks guys and special thank to durden_tyler for his solution,
I guess only expert are welcome here 👍.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
Am trying to transpose a set of rows into a set of comma separated values.
For eg. if the output of
ps -ef | tail +2 | awk 'BEGIN{ FS=" " } { print $2 }'
is
0
1
3
4
I need to transpose it to -
'0','1','3','4'
Am currently trying - (4 Replies)
Discussion started by: iamwha1am
4 Replies
2. Shell Programming and Scripting
Any tips on how I can awk the input data to display the desired output per below? Thanking you in advance.
input test data:
2
2010-02-16 10:00:00
111111111111 bytes
99999999999 bytes
90%
4
2010-02-16 12:00:00
333333333333 bytes
77777777777 bytes
88%
5
2010-02-16 11:00:00... (4 Replies)
Discussion started by: ux4me
4 Replies
3. Shell Programming and Scripting
Need to transpose in awk rows to column like this:
input:
A1,6,5,4 3,2,1,
A2,8,7,9,10,11,12,13,14
A3,1,2,3,5,7,8,9
A4,9,4,8,1,5,3,
output:
A1,1
A1,2
A1,4
...
A2,7
A2,8
...
A3,1
A3,2
...
A4,1
A4,3 (5 Replies)
Discussion started by: sdf
5 Replies
4. Shell Programming and Scripting
Hi Experts,
Can you please help me in transposing Datefield from rows to column and calculate the time difference for each of the Jobids:
Input File:
08/23/2012 12:36:09,JOB_5340
08/23/2012 12:36:14,JOB_5340
08/23/2012 12:36:22,JOB_5350
08/23/2012 12:36:26,JOB_5350
Required Output:... (6 Replies)
Discussion started by: asnandhakumar
6 Replies
5. Shell Programming and Scripting
Gurus:
How can I transpose the output below to a format in which I can plot a graph to show VSZ memory usage by PIDs?
stdout:
Tue Jan 22 07:29:19 CUT 2013
42336296 1841272 java wilyadm
21889232 438616 jlaunch sidadm
42532994 414336 jlaunch sidadm
Tue Jan 22 07:49:20 CUT 2013... (1 Reply)
Discussion started by: ux4me
1 Replies
6. Shell Programming and Scripting
I can no longer find my commands, but I use to be able to transpose data with common fields from a single column to rows using a command line. My data is separated as follows:
NAME=BOB
ADDRESS=COLORADO
PET=CAT
NAME=SUSAN
ADDRESS=TEXAS
PET=BIRD
NAME=TOM
ADDRESS=UTAH
PET=DOG
I would... (7 Replies)
Discussion started by: docdave78
7 Replies
7. Shell Programming and Scripting
How to change the uploaded weekly file data to the following format?
New Well_Id,Old Well_Id,District,Thana,Date,Data,R.L,WellType,Lati.,Longi.
BAG001,PT006,BARGUNA,AMTALI,1/2/1978,1.81,2.29,Piezometer,220825,901430
BAG001,PT006,BARGUNA,AMTALI,1/9/1978,1.87,2.29,Piezometer,220825,901430... (3 Replies)
Discussion started by: sara.nowreen
3 Replies
8. Shell Programming and Scripting
Dear all,
Plz let me know syntax for transposing rows into column in perl,
I am having 30 csv files which are merged into a single xls sheet.
but i want to transpose each row into column in excel sheet in each tab (1 CSV = 1tab in xls sheet)
example is as below
... (0 Replies)
Discussion started by: sagar_1986
0 Replies
9. Programming
Hi,
i am having an HDFS file which is comma seperated, i need to transpose from rows to column only the header columns
text.csv
cnt,name,place
1,hi,nz
2,hello,aus
I need
cnt,
name,
place
while using below command in hadoop getting the error
hadoop fs -fmt -1 text.csv (0 Replies)
Discussion started by: rohit_shinez
0 Replies
10. UNIX for Beginners Questions & Answers
Hello Everyone,
I am very new to the world of regular expressions. I am trying to use grep/sed for the following:
Input file is something like this and there are multiple such files:
abc
1
2
3
4
5
***END***
abc
6
7
8
9
***END***
abc
10 (2 Replies)
Discussion started by: shellnewuser
2 Replies
LEARN(1) General Commands Manual LEARN(1)
NAME
learn - computer aided instruction about UNIX
SYNOPSIS
learn [ -directory ] [ subject [ lesson ] ]
DESCRIPTION
Learn gives Computer Aided Instruction courses and practice in the use of UNIX, the C Shell, and the Berkeley text editors. To get started
simply type learn. If you had used learn before and left your last session without completing a subject, the program will use information
in $HOME/.learnrc to start you up in the same place you left off. Your first time through, learn will ask questions to find out what you
want to do. Some questions may be bypassed by naming a subject, and more yet by naming a lesson. You may enter the lesson as a number
that learn gave you in a previous session. If you do not know the lesson number, you may enter the lesson as a word, and learn will look
for the first lesson containing it. If the lesson is `-', learn prompts for each lesson; this is useful for debugging.
The subject's presently handled are
files
editor
vi
morefiles
macros
eqn
C
There are a few special commands. The command `bye' terminates a learn session and `where' tells you of your progress, with `where m'
telling you more. The command `again' re-displays the text of the lesson and `again lesson' lets you review lesson. There is no way for
learn to tell you the answers it expects in English, however, the command `hint' prints the last part of the lesson script used to evaluate
a response, while `hint m' prints the whole lesson script. This is useful for debugging lessons and might possibly give you an idea about
what it expects.
The -directory option allows one to exercise a script in a nonstandard place.
FILES
/usr/share/learn subtree for all dependent directories and files
/usr/tmp/pl* playpen directories
$HOME/.learnrc startup information
SEE ALSO
csh(1), ex(1)
B. W. Kernighan and M. E. Lesk, LEARN - Computer-Aided Instruction on UNIX
BUGS
The main strength of learn, that it asks the student to use the real UNIX, also makes possible baffling mistakes. It is helpful, espe-
cially for nonprogrammers, to have a UNIX initiate near at hand during the first sessions.
Occasionally lessons are incorrect, sometimes because the local version of a command operates in a non-standard way. Occasionally a lesson
script does not recognize all the different correct responses, in which case the `hint' command may be useful. Such lessons may be skipped
with the `skip' command, but it takes some sophistication to recognize the situation.
To find a lesson given as a word, learn does a simple fgrep(1) through the lessons. It is unclear whether this sort of subject indexing is
better than none.
Spawning a new shell is required for each of many user and internal functions.
The `vi' lessons are provided separately from the others. To use them see your system administrator.
7th Edition October 22, 1996 LEARN(1)