Hi Glynn,
Thank you so much for your answer.
I've used your code in a script and run:
# cat passwords.sql | your_script
but all i get is a file named typescrypt with this content:
Script started on Sun Dec 24 23:24:28 2006
What am i doing wrong ?
Warm Regards,
Mário Gamito
Glynn Clements wrote:
Mário Gamito wrote:
I have this file in the following format:
tarta 16340309 marsanpin brigittamario@xxxxxx
lms doom123 Luis Miguel Sequeira lms@xxxxxx
jura teste Juraci jgweb@xxxxxxxxxx
jsilva t00lt0ya5 Jorge Silva jsilva@xxxxxxx
tchock mail#4829 tchock engDias@xxxxxx
reporterx noname Duarte Oliveira mtbf99@xxxxxxx
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:/
-
To unsubscribe from this list: send the line "unsubscribe linux-admin" in
the body of a message to majordomo@xxxxxxxxxxxxxxx
More majordomo info at http://vger.kernel.org/majordomo-info.html
