05-19-2003
Move data from Column to Row
Hi all,
I have a file with several columns of data, eg:
A B C D
1 2 5 1
2 2 2 2
8 4 4 4
4 2 3 4
10 9 4 4
9 7 1 2
I need to get the values from, say, column B and place them into a string separated by a semicolon, eg:
2;2;4;2;9;7
Does anyone have any ideas how to do this? Any help would be massively appreciated! Thanks.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi Guys,
I have a file as follows:
a 1
b 786
c 90709
d 99
a 9875
b 989
c 887
d 111
I want:
a 1 9875
b 786 989 (3 Replies)
Discussion started by: npatwardhan
3 Replies
2. Shell Programming and Scripting
Dear friends,
Below is my program and current output. I wish to have 3 or 4 column output in order to accomodate in single page. i do have subsequent command to process after user enter the number.
Program
COUNT=1
for MYDIR in `ls /`
do
VOBS=${MYDIR}
echo "${COUNT}. ${MYDIR}"
... (4 Replies)
Discussion started by: baluchen
4 Replies
3. Shell Programming and Scripting
Hello,
I have an input file like the following:
11_3_4
2_1_35
3_15__
_16989
Where '_' is a space. The data is in a table. Is there a way for the program to prompt the user for x1,y1 and x2,y2, where x1,y1 is the desired number (for example x=6 y=4 is a value of 4) and move to a desired spot... (2 Replies)
Discussion started by: jl487
2 Replies
4. Shell Programming and Scripting
Hi, I need somebody's help with sorting data with awk.
I've got a file:
10 aaa 4584
12 bbb 6138
20 ccc 4417
21 ddd 7796
10 eee 7484
12 fff ... (5 Replies)
Discussion started by: killerbee
5 Replies
5. UNIX for Advanced & Expert Users
Hi,
I want to convert a 3-column data to 3-row data using shell script. Any suggestion in this regard is highly appreciated.
Thanks. (4 Replies)
Discussion started by: sktkpl
4 Replies
6. Shell Programming and Scripting
Hello guys.
Please can you help me with this.. Thanks in advance:b:
Input file
2134 6371 N
2150 6371 M
2166 6371 S
2138 6417 N
2154 6417 M
2170 6417 S
2157 6603 N
2173 6603 M
2189 6603 S
desired uotput
6371 2134N 2150M 2166S
6417 2138N 2154M 2170S... (2 Replies)
Discussion started by: jiam912
2 Replies
7. Shell Programming and Scripting
Hi
FileA.txt
E_TIM 16,
ETE 15,
EOND 26,
EEC 81,
E_1 un,
E_2 un,
E_3 un,
E_4 284,
E_TIM 17,
ETE 15,
EOND 29,
EEC 82,
E_1 un,
E_2 un,
E_3 un,
E_4 249, (6 Replies)
Discussion started by: asavaliya
6 Replies
8. Shell Programming and Scripting
HI Guys,
I just want to replace data for First Column and Row Cell(1,1)
Input :-
Hello A B C
X 1 2 3
Y 4 5 6
Z 7 8 9
Output:-
Byee A B C
X 1 2 3
Y 4 5 6
Z 7 8 9
From Hello to Byee .....And The Each file have Different String. (3 Replies)
Discussion started by: pareshkp
3 Replies
9. Shell Programming and Scripting
HI Guys,
I have below Input :-
X L1 5
Y L1 10
Z L1 15
X L2 20
Y L2 12
Z L2 15
X L3 100
Y L3
Z L3 300
Output:-
ID L1 L2 L3
X 5 10 15
Y 20 12 15
Z 100 Null 300 (11 Replies)
Discussion started by: pareshkp
11 Replies
10. Shell Programming and Scripting
Hi team,
I have below sample file.
$ cat sample
dn: MSISDN=400512345677,dc=msisdn,ou=NPSD,serv=CSPS,ou=servCommonData,dc=stc
structuralObjectClass: NphData
objectClass: NphData
objectClass: MSISDN
entryDS: 0
nodeId: 35
createTimestamp: 20170216121047Z
modifyTimestamp: 20170216121047Z... (3 Replies)
Discussion started by: shanul karim
3 Replies
COLRM(1) BSD General Commands Manual COLRM(1)
NAME
colrm -- remove columns from a file
SYNOPSIS
colrm [start [stop]]
DESCRIPTION
The colrm utility removes selected columns from the lines of a file. A column is defined as a single character in a line. Input is read
from the standard input. Output is written to the standard output.
If only the start column is specified, columns numbered less than the start column will be written. If both start and stop columns are spec-
ified, columns numbered less than the start column or greater than the stop column will be written. Column numbering starts with one, not
zero.
Tab characters increment the column count to the next multiple of eight. Backspace characters decrement the column count by one.
ENVIRONMENT
The LANG, LC_ALL and LC_CTYPE environment variables affect the execution of colrm as described in environ(7).
EXIT STATUS
The colrm utility exits 0 on success, and >0 if an error occurs.
SEE ALSO
awk(1), column(1), cut(1), paste(1)
HISTORY
The colrm command appeared in 3.0BSD.
BSD
August 4, 2004 BSD