|
|
Sponsored Content
Top Forums
UNIX for Dummies Questions & Answers
converting unique identifiers in a column using conversion file
Post 302489787 by peanuts48 on Friday 21st of January 2011 03:50:12 PM
01-21-2011
|
|
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
Request To guide me in writing a shell program for the following requirement:
Example:if the Input File contains the follwing data
Input File Data:
80723240029,12,323,443,88,98,7,98,67,87
80723240030,12,56,6,,,3,12,56,6,7,2,3,12,56,6,7,2,3,88,98,7,98,67,87... (5 Replies)
Discussion started by: srinikal
5 Replies
2. Shell Programming and Scripting
Hi all,
I have a huge csv file with the following format of data,
Num SNPs, 549997
Total SNPs,555352
Num Samples, 157
SNP, SampleID, Allele1, Allele2
A001,AB1,A,A
A002,AB1,A,A
A003,AB1,A,A
...
...
...
I would like to write out a list of unique SNP (column 1). Could you... (3 Replies)
Discussion started by: phoeberunner
3 Replies
3. Shell Programming and Scripting
I have a file containing data like so:
2012-01-02 GREEN 4
2012-01-02 GREEN 6
2012-01-02 GREEN 7
2012-01-02 BLUE 4
2012-01-02 BLUE 3
2012-01-02 GREEN 4
2012-01-02 RED 4
2012-01-02 RED 8
2012-01-02 GREEN 4
2012-01-02 YELLOW 5
2012-01-02 YELLOW 2
I can't always predict what the... (4 Replies)
Discussion started by: rich@ardz
4 Replies
4. UNIX for Dummies Questions & Answers
Hi !
I have input.tab with one column containing Item IDs under a number format (the second column is the Location of this item):
Location Item ID
rack1 12; 35; 43
rack35 23; 894; 5478; 98
etc...
(The number of Items per row is variable. Item IDs in a same field are... (17 Replies)
Discussion started by: lucasvs
17 Replies
5. Shell Programming and Scripting
Dear fellows, I need your help.
I'm trying to write a script to convert a single column into multiple rows.
But it need to recognize the beginning of the string and set it to its specific Column number.
Each Line (loop) begins with digit (RANGE).
At this moment it's kind of working, but it... (6 Replies)
Discussion started by: AK47
6 Replies
6. Linux
cat sample.csv
ID,Name,no
1,AAA,1
2,BBB,1
3,AAA,1
4,BBB,1
cut -d',' -f2 sample.csv | sort | uniq
this gives only the 2nd column values
Name
AAA
BBB
How to I get all the columns of CSV along with this? (1 Reply)
Discussion started by: sanvel
1 Replies
7. Shell Programming and Scripting
Hi Folks,
I have the below feed file named abc1.txt in which you can see there is a title and below is the respective values in the rows and it is completely pipe delimited file ,.
... (4 Replies)
Discussion started by: punpun66
4 Replies
8. Shell Programming and Scripting
I would like to merge two tables based on column 1:
File 1:
1 today
1 green
2 tomorrow
3 red
File 2:
1 a lot
1 sometimes
2 at work
2 at home
2 sometimes
3 new
4 a lot
5 sometimes
6 at work (4 Replies)
Discussion started by: BSP
4 Replies
9. Shell Programming and Scripting
Hello Team,
I need your help on the following:
My input file a.txt is as below:
3330690|373846|108471
3330690|373846|108471
0640829|459725|100001
0640829|459725|100001
3330690|373847|108471
Here row 1 and row 2 of column 1 are identical but corresponding column 2 value are... (4 Replies)
Discussion started by: angshuman
4 Replies
10. Shell Programming and Scripting
Hi Experts,
I have csv file with 30, 40 columns
Pasting just 2 column for problem description.
Need to print error if below combination is not present in file
check for column-1 (DocumentNumber) and filter columns where value in DocumentNumber field is same.
For all such rows, the field... (7 Replies)
Discussion started by: as7951
7 Replies
LEARN ABOUT LINUX
aic
AIC(4) BSD/i386 Kernel Interfaces Manual AIC(4) NAME
aic -- Adaptec AIC-6260 and AIC-6360 SCSI driver SYNOPSIS
device aic In /boot/device.hints: hint.aic.0.at="isa" DESCRIPTION
The aic driver provides support for the Adaptec AIC-6260 and AIC-6360 SCSI controller chips. Many systems that use these controller chips do not have a boot ROM and therefore cannot be booted from. HARDWARE
The adapters supported by the aic driver include: o Adaptec AHA-1505 (ISA) o Adaptec AHA-1510A, AHA-1510B (ISA) o Adaptec AHA-1520A, AHA-1520B (ISA) o Adaptec AHA-1522A, AHA-1522B (ISA) o Adaptec AHA-1535 (ISA) o Creative Labs SoundBlaster SCSI host adapter (ISA) o Adaptec AHA-1460, AHA-1460B, AHA-1460C, AHA-1460D (PC Card) o Adaptec AHA-1030B, AHA-1030P (PC98) o NEC PC-9801-100 (PC98) SEE ALSO
aha(4), ahb(4), ahc(4), cd(4), ch(4), da(4), intro(4), sa(4) BUGS
The driver does not work well with multiple devices on the SCSI bus. The driver works well with devices like CDROMs and Tape drives. The driver works not so well with disk drives. The PC Card version appears to work better than the ISA version, but that may be due to differing levels of testing of the devices. BSD November 8, 2003 BSD