Re: Changes in file (huge problem)

Mário Gamito wrote:

> I have this file in the following format:
> 
> tarta 16340309 marsanpin [email protected]
> lms doom123 Luis Miguel Sequeira [email protected]
> jura teste Juraci [email protected]
> jsilva t00lt0ya5 Jorge Silva [email protected]
> tchock  mail#4829 tchock  [email protected]
> reporterx noname Duarte Oliveira [email protected]
> erkulix brunoverab4 Bruno Cruz
> 
> First field is a username;
> Second field is a password in clear text;
> *Last field is the email;
> The field between is the name.
> 
> As you can see, some lines don't have the name, and names have an unknow 
> number of words.
> Some lines don't have the e-mail.
> 
> What i need is:

> Substitute spaces for ":", *except* of course the spaces within the name.

#!/usr/bin/sed -f
s/^\([^ ]\+\) \+\([^ ]\+\) \+\(.\+\) \+\([^ @]\+@[^ @]\+\) *$/\1:\2:\3:\4/
s/^\([^ ]\+\) \+\([^ ]\+\) \+\([^ @]\+@[^ @]\+\) *$/\1:\2::\3/
s/^\([^ ]\+\) \+\([^ ]\+\) \+\(.\+\) *$/\1:\2:\3:/

-- 
Glynn Clements <[email protected]>
-
To unsubscribe from this list: send the line "unsubscribe linux-admin" in
the body of a message to [email protected]
More majordomo info at  http://vger.kernel.org/majordomo-info.html