10 More Discussions You Might Find Interesting
1. UNIX for Beginners Questions & Answers
I have data of an excel files as given below,
file1
org1_1 1 1 2.5 100
org1_2 1 2 5.5 98
org1_3 1 3 7.2 88
file2
org2_1 1 1 2.5 100
org2_2 1 2 5.5 56
org2_3 1 3 7.2 70
I have multiple excel files as above shown.
I have to copy column 1, column 4 and paste into a new excel file as... (26 Replies)
Discussion started by: dineshkumarsrk
26 Replies
2. Shell Programming and Scripting
#cat data.txt
file1 folder1
file2 thisforfile2
file3 thisfolderforfile3
lata4 folder4
step 1: create the folder first in column 2
for i in `awk '{print $2}' data.txt`
do
mkdir /home/data/$i
done
step 2: locate the files in column1 and stored them into a file
for i in... (17 Replies)
Discussion started by: kenshinhimura
17 Replies
3. Shell Programming and Scripting
My I/p is
Col1|Col2|Col3
2116209997932|POSIX INC|POSIX
2116209997933|POSIX INC|POSIX
2116210089479|POSIX INC|POSIX
2116210180502|POSIX INC|POSIX
2116210512279|POSIX INC|Aero
2116210516838|POSIX INC|POSIX
2116210534342|POSIX INC|postal
2116210534345|POSIX INC|postal ... (6 Replies)
Discussion started by: nikhil jain
6 Replies
4. Shell Programming and Scripting
I have data that looks like this:
chr1 mm9_knownGene exon 155747075 155747189 0.000000 + . gene_id "Glul"; transcript_id "uc007daq.1";
chr1 mm9_knownGene exon 155750064 155750076 0.000000 + . gene_id "Glul";... (3 Replies)
Discussion started by: pbluescript
3 Replies
5. UNIX for Advanced & Expert Users
Hi All,
I have a fixedwidth file of length 3000. Now i want to copy a column of 4 chars i.e( length 1678-1681) to column 1127 – 1171 to the same file.
Please let me know how can i achive using a single command in fixed width file.
Also source column length is 4 chars and target column length... (4 Replies)
Discussion started by: kiranparsha
4 Replies
6. Shell Programming and Scripting
Hello,
My DATA:
PLOKIJ1234G 12 13 14 15
PLOKIJ1234E 12 13 14 15
PLOKIJ1234F 12 22 33 44
IJNUHB12346 55 66 77 88
IJNUHB12347 32 34 45 67
IJUHU345D 23 23 22 33
IJUHYG23E 11 24 23 23
IJUHYG23F 77 88 99 00
output:
PLOKIJ1234 PLOKIJ1234G 12 13 14 15
PLOKIJ1234... (11 Replies)
Discussion started by: asavaliya
11 Replies
7. UNIX for Dummies Questions & Answers
Dear Gurus,
I have a unix file 2 columns (# delimited) with the following data:
ZTXX_CTBR1-ZBRAN1#ZTXX_CTBR1-ZBRAN_DESC#
01#CASH & CARRY#
02#DRUGSTORE - RX#
04#SUPERMARKET#
05#HYPERMARKET#
17#DRUGSTORE - NO RX#
I would like to have a code that will do 2 things:
1. Delete the header... (16 Replies)
Discussion started by: chumsky
16 Replies
8. Shell Programming and Scripting
Hi,
i have file which contains only one record like below
a|b|c|....
The no of columns is not known. The expected output is as below:
a|a|b|b|c|c|...
Please provide me your suggestions.
OS: unix
Thanks,
Selva (7 Replies)
Discussion started by: bharathappriyan
7 Replies
9. Shell Programming and Scripting
Simple question ..What is the easiest way to list my output in a column
like so
dddd dddd dddd dddd
output
dddd
dddd
dddd
dddd
Thanks (3 Replies)
Discussion started by: bombcan
3 Replies
10. UNIX for Advanced & Expert Users
Hello,
Anybody out there knows how to copy a column data into a blank column using unix command?
Thanks (1 Reply)
Discussion started by: folashandy
1 Replies