|
|
Sponsored Content
Top Forums
Shell Programming and Scripting
Merge column headers and transpose
Post 302737943 by giuliangiuseppe on Friday 30th of November 2012 05:16:59 AM
11-30-2012
|
|
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I have a text file in unix with a layout like this
Column 1 - 1-12
Column 2 - 13-39
Column 3 - 40-58
Column 4 - 59-85
Column 5 - 86-120
Columbn 6 - 121-131
The file also has a header on the first 6 lines of each page. Each page is 51 lines long. So I want to remove the header from each... (30 Replies)
Discussion started by: DerangedNick
30 Replies
2. Shell Programming and Scripting
cat ABC.log | egrep "Error 500" >> /tmp/Logs.log
egrep "<Mango>.*<.Mango>" Logs.log | sed -e "s/^.*<Mango/<Mango/" | cut -f2 -d">"| cut -f1 -d"<" >> /tmp/temp1.xls
egrep "<Apple>.*<.Apple>" Logs.log | sed -e "s/^.*<Apple/<Apple/" | cut -f2 -d">"| cut -f1 -d"<" >> /tmp/temp2.xls
print Heading1,... (1 Reply)
Discussion started by: pk_eee
1 Replies
3. UNIX for Dummies Questions & Answers
Hi All,
I am new to UNIX can you please help me to sort a file with different columns
my file looks like this
$ cat gaut.txt
UID PID PPID PGID SID C STIME TTY TIME CMD
liveuser 3008 2892 3008 3008 0 11:58 ? 00:00:00 gnome-session
liveuser 3019 1 ... (8 Replies)
Discussion started by: cgk1983
8 Replies
4. Shell Programming and Scripting
Hi,
I found the following awk script to transpose multiple (3) columns to multiple rows:
#===
BEGIN {FS=","}
{
for (i=1;i<=NF;i++)
{
arr=$i;
if(nf<= NF)
nf=NF;
}
nr=NR
}
END {
for(i=1;i<=nf;i++)
{ (8 Replies)
Discussion started by: Gery
8 Replies
5. Shell Programming and Scripting
Looking to join three files and then transpose some columns from multiple rows into a single row.
File Info:
FIELD TERMINATED BY '^'
ENCLOSED BY '~'
LINE TERMINATED BY '\r\n'
FIRST FILE (FOOD_DES.txt)
~01001~^~0100~^~Butter, salted~^~BUTTER,WITH... (2 Replies)
Discussion started by: mkastin
2 Replies
6. Shell Programming and Scripting
Hi All,
I'm looking for a script which can transpose field names from column headers to values in one column.
for example, the input is:
IDa;IDb;IDc;PARAM1;PARAM2;PARAM3;
a;b;c;p1val;p2val;p3val;
d;e;f;p4val;p5val;p6val;
g;h;i;p7val;p8val;p9val;
into the output like this:
... (6 Replies)
Discussion started by: popesk
6 Replies
7. Shell Programming and Scripting
Hi
I have 5 columns like this
a b c d e
f g h i j
k l m n o
From 2nd column till the 5th column of every record, I would like to transpose them as rows, so my output file contains only one row
a
b
c
d
e
f
g
h
i
j (9 Replies)
Discussion started by: jacobs.smith
9 Replies
8. Shell Programming and Scripting
Hi Folks,
My input file is like this
cat input
abcd:efgh:jklm 123,456,67,78,89,90
hi:kil:op 76,78,12,3456,
unix:linux:shell:bash 111,111
My expected output
abcd:efgh:jklm hi:kil:op unix:linux:shell:bash
123 76 111
456 78 111
67 12
78 3456
89
90 (5 Replies)
Discussion started by: jacobs.smith
5 Replies
9. Shell Programming and Scripting
hello gurus,
Somebody must have done this before, I couldn't find anything. Please redirect me if this was solved before, and if not please help.
To the problem now, I have multiple csv files (about 1000) which I need to concatenate by column header. The final file should have a superset... (4 Replies)
Discussion started by: abh.kumar
4 Replies
10. Shell Programming and Scripting
Gents,
Transpose from row to column, taking in consideration the first column, which contends the date.
Input file
72918,111000009,111000009,111000009,111000009,111000009,111000009,111000009,111000009,111000009
72918,2356,2357,2358,2359,2360,2361,2362,2363,2364
72918,0,0,0,0,0,0,0,0,0... (12 Replies)
Discussion started by: jiam912
12 Replies
LEARN ABOUT MOJAVE
evim
EVIM(1) General Commands Manual EVIM(1) NAME
evim - easy Vim, edit a file with Vim and setup for modeless editing SYNOPSIS
evim [options] [file ..] eview DESCRIPTION
eVim starts Vim and sets options to make it behave like a modeless editor. This is still Vim but used as a point-and-click editor. This feels a lot like using Notepad on MS-Windows. eVim will always run in the GUI, to enable the use of menus and toolbar. Only to be used for people who really can't work with Vim in the normal way. Editing will be much less efficient. eview is the same, but starts in read-only mode. It works just like evim -R. See vim(1) for details about Vim, options, etc. The 'insertmode' option is set to be able to type text directly. Mappings are setup to make Copy and Paste work with the MS-Windows keys. CTRL-X cuts text, CTRL-C copies text and CTRL-V pastes text. Use CTRL-Q to obtain the original meaning of CTRL-V. OPTIONS
See vim(1). FILES
/usr/local/lib/vim/evim.vim The script loaded to initialize eVim. AKA
Also Known As "Vim for gumbies". When using evim you are expected to take a handkerchief, make a knot in each corner and wear it on your head. SEE ALSO
vim(1) AUTHOR
Most of Vim was made by Bram Moolenaar, with a lot of help from others. See the Help/Credits menu. 2002 February 16 EVIM(1)