sorting file


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting sorting file
# 1  
Old 06-15-2005
sorting file

hi everyone, i have a document where i have email addresess and names, i need to check if the email addresses are uniq, if they repeat erase one of them, how can i do that?

document sample:

aD00763357@cucei.udg.mx,ABRAHAM ANTONIO SEVERIANO
a199721111@cucei.udg.mx,ABRAHAM GONZALEZ MIGUEL
a090784803@cucei.udg.mx,ABREGO FLORES JAIRO ALONSO
a088667212@cucei.udg.mx,ABREU GALAN ALEJANDRO
a394204925@cucei.udg.mx,ABREU MARISCAL JOSE MANUEL
aD03861546@cucei.udg.mx,ABREU MARISCAL LUIS RODRIGO
a084461709@cucei.udg.mx,ABREW GARCIA ALFONSO
a396242948@cucei.udg.mx,ABRICA MOJARRO LAURA MARISELA
a193209451@cucei.udg.mx,ABUNDIO RAMIREZ BERNARDO
a198121765@cucei.udg.mx,ABUNDIS PANTOJA HUGO MARTIN
a398298339@cucei.udg.mx,ABUNDIS RUIZ BERENICE
a394210925@cucei.udg.mx,ABUNDIS RUIZ RAQUEL
a393046129@cucei.udg.mx,ACEVEDO ACEVEDO JUAN ENRIQUE
a300581275@cucei.udg.mx,ACEVEDO BERNAL GERMAN
a399273925@cucei.udg.mx,ACEVEDO CARDENAS KARLA GUADALUPE
a396206372@cucei.udg.mx,ACEVEDO HERNANDEZ ERICK
a093781856@cucei.udg.mx,ACEVEDO MANRIQUEZ MARIA MARINA
a394006445@cucei.udg.mx,ACEVEDO PARRA HECTOR RUBEN
a300205133@cucei.udg.mx,ACEVEDO PARRA ERIK EDUARDO
# 2  
Old 06-15-2005
sort -u -t ',' -k 1,1 yourDocument
# 3  
Old 06-15-2005
if the file is already sorted ... see "man uniq" ...

if the file has not been sorted ... see "man sort" and/or "man uniq" as required
# 4  
Old 06-22-2005
thanks guy's

Quote:
Originally Posted by vgersh99
sort -u -t ',' -k 1,1 yourDocument
wow... thank you very much, that was really simple solution, i was writing a script... very complicated.. and it didnt even worked anyway... Smilie

Code:
#!/usr/bin/bash
ARCH=cuaad.txt
sort $ARCH >> temp
cp temp $ARCH
rm temp
tr ' ' '%' < $ARCH  >> cuceitmp.txt
cp cuceitmp.txt $ARCH
for x in `cat $ARCH`
do
echo $x > x.txt
a=`cut -d, -f1 x.txt`
b=`cut -d, -f2 x.txt`
grep $a $ARCH >> tmpswap.txt
wc -l tmpswap.txt > count.txt
tr ' ' ':' < count.txt >> counttmp.txt
n=`cut -d: -f7 counttmp.txt`
echo $n
rm tmpswap.txt
if [$n != 1];
then
echo $a,$b Repetido $n veces... >> DUPL
else
echo $a,$b >> tmp.txt
fi
done
tr '%' ' ' < $ARCH

it never really worked, and is awfully slow Smilie

what is that 1,1 thing you use, is it awk or something like that?
# 5  
Old 06-22-2005
Quote:
Originally Posted by vgersh99
sort -u -t ',' -k 1,1 yourDocument
Quote:
Originally Posted by sx3v1l_1n51de
what is that 1,1 thing you use, is it awk or something like that?
naah, nothing like that - 'man sort'
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Need help in Sorting a file

Hi Unix Admins, I wanted to sort a file in a specific order, i.e the input file contains two fields and the first column is not unique and had to be sorted. example Input File ------- 2014-10-21:Rand1 2014-11-02:Rand2 2014-11-02:Rand3 2014-11-02:Rand4 2014-11-03:Rand5 2014-11-04:Rand6... (4 Replies)
Discussion started by: Naveenezone
4 Replies

2. Solaris

What about sorting a 5G file?

Hi Guys, My client (dear clients, I hate to love you) has the funky idea of sorting a 5G flat file. Certainly enough, this is taking forever and also fulls the / of our machine. Any idea of how we could proceed to make this a little bit more efficient? Maybe by forcing sort to "stay in... (7 Replies)
Discussion started by: plmachiavel
7 Replies

3. UNIX for Dummies Questions & Answers

Sorting data in file based on field in another file

Hi, I have two files, one of which I would like to sort based on the order of the data in the second. I would like to do this using a simple unix statement. My two files as follows: File 1: 12345 1 2 2 2 0 0 12349 0 0 2 2 1 2 12350 1 2 1 2 2 2 . . . File2: 12350... (3 Replies)
Discussion started by: kasan0
3 Replies

4. UNIX for Dummies Questions & Answers

sorting s file

how would i sort a file on the third column based on numerical value instead of the ASCII order? (1 Reply)
Discussion started by: trob
1 Replies

5. Shell Programming and Scripting

Finding & Moving Oldest File by Parsing/Sorting Date Info in File Names

I'm trying to write a script that will look in an /exports folder for the oldest export file and move it to a /staging folder. "Oldest" in this case is actually determined by date information embedded in the file names themselves. Also, the script should only move a file from /exports to... (6 Replies)
Discussion started by: nikosey
6 Replies

6. Shell Programming and Scripting

Sorting file

I have the file as follow: A: 60 B: 80 C: 40 D: 11 E: 100 I want to sort the file and get the output to file as follow: E: 100 B: 80 A: 60 C: 40 D: 11 Could any one help me please? (1 Reply)
Discussion started by: moutaz1983
1 Replies

7. Shell Programming and Scripting

file sorting

i have a data in afile like this ************************************** sree sree@yahoo.com 98662323432 ************************************* phani phani@yahoo.com 98662323344 ************************************* i want to sort the file with respect to name. how can i do this. thank... (5 Replies)
Discussion started by: phani_sree
5 Replies

8. Programming

regarding file sorting

i ahve a file like: ************************************* sree 122132 12321 *********************************** phani 21321 3213214 ****************************** dddsds 213213123 23213213 ******************************* i want to sort the file with respect to name how we can do this... (1 Reply)
Discussion started by: phani_sree
1 Replies

9. Shell Programming and Scripting

Sorting a file

hello all, I have a file with two numbers on each line, comma separated. I want to sort the contents of the file in increasing order (smallest to largest) of the numbers on the second line. i.e: 23,3 25,2 27,12 to become 25,2 23,3 27,12 Does anyone know how I can do this? Thanks... (2 Replies)
Discussion started by: Khoomfire
2 Replies

10. Shell Programming and Scripting

Help sorting file.

Hi, I have this file (filex) 07-11-2003 10:11:12!cccc!ddd!eeeeeeee 07-11-2003 09:11:11!dddd!kkkkk!xxxxxx 09-12-2003 14:18:43!aaaa!bbbbb!cccc where I need to sort it by date+time in this order: 09-12-2003 14:18:43!aaaa!bbbbb!cccc 07-11-2003 10:11:12!cccc!ddd!eeeeeeee 07-11-2003... (3 Replies)
Discussion started by: gio123bg
3 Replies
Login or Register to Ask a Question