Need help on renaming a file

rhbegin · 07-16-2010, 04:38 PM

I have a file called unsubscribe with the following data:

user1
user2
user3
user4

I want to have it look like this for all users:

user1@domain.com;0;
user2@domain.com;0;
user3@domain.com;0;
user4@domain.com;0;

Any help would be greatly appreciated.

ncsuapex · 07-16-2010, 04:50 PM

You can use sed to append the common info after each user. It's a lot easier if each username has the exact same number of characters. If not Im sure there is a way in sed to append to after the last character in a line.

Look for some examples on how to use "sed".

Sergei Steshenko · 07-16-2010, 04:55 PM

Quote:

Originally Posted by rhbegin

I have a file called unsubscribe with the following data:

user1
user2
user3
user4

I want to have it look like this for all users:

user1@domain.com;0;
user2@domain.com;0;
user3@domain.com;0;
user4@domain.com;0;

Any help would be greatly appreciated.

The thread name is wrong - you are not trying to rename a file, you are trying to modify lines inside the file.

As an alternative to what's been already recommended read

man 1 paste
.

colucix · 07-16-2010, 05:46 PM

As Sergei already stated, this is not a problem about renaming but about how to concatenate strings by reading one of them from a file. Indeed the suggested sed solution is the most straightforward, since it lets you edit the file in place, e.g.

Code:

sed -i.bck 's/$/@domain.com;0;/' unsubscribe

but it mostly depend on the language/application of your choice, e.g. in pure bash:

Code:

while read line; do echo "${line}@domain.com;0;"; done < unsubscribe

using awk:

Code:

awk '$0=$0"@domain.com;0;"' unsubscribe

and so on...

MTK358 · 07-18-2010, 08:07 AM

Appends a string to every non-blank line:

Code:

awk '/.+/ { print $0 "@domain.com;0;" }'

rhbegin · 07-18-2010, 06:00 PM

I am a beginner in bash, thank you so much for the prompt replies.

Would this be the correct solution then:

awk '/.+/ { print $0 "@domain.com;0;" }' filename

MTK358 · 07-18-2010, 07:02 PM

I guess so.

ghostdog74 · 07-18-2010, 07:38 PM

Code:

awk 'NF{$0=$0"@domain.com;0;"}1' file

rhbegin · 07-18-2010, 08:42 PM

That did the trick!

Thank you!!