Unix & Linux Stack Exchange is a question and answer site for users of Linux, FreeBSD and other Un*x-like operating systems. It only takes a minute to sign up.
Sign up to join this community
I have a csv file with following details :
Userid,First Name,Last Name
jaina24,Aayush,Jain
my requirement is to add a new column in the existing file like this :
Userid,Email Address,First Name,Last Name
jaina24,[email protected],Aayush, Jain
2nd column should copy value from first column and then append @xyz.com to it.
You can use something like (if you have exactly 3 fields):
awk -F\, 'FNR==1 {print $1",Email Address,"$2","$3} FNR!=1{print $1","$1"@xyz.com,"$2","$3}' input_file
You could use awk
awk 'BEGIN{FS=OFS=","}{$1=$1 OFS (FNR>1 ? $1 "@xyz.com" : "Email address")}1' file
Or sed
sed '1s/[^,]*/&,Email address/;1!s//&,&@xyz.com/' flie
Or bash (but don't use bash for processing text - see Why is using a shell loop to process text considered bad practice?)
$ perl -F, -lane 'if ($. == 1) {
splice @F, 1, 0, "Email Address";
} else {
splice @F, 1, 0,$F[0] . "\@xyz.com";
};
print join ",", @F' input.csv
Userid,Email Address,First Name,Last Name
jaina24,[email protected],Aayush,Jain
Input File
Userid,First Name,Last Name
jaina24,Aayush,Jain
Rob738,Rob,Everhard
Scorch661,Samuel,Scorhezi
command
[ ~]# awk -F, 'NR==1, OFS="," {print $1, "Email Address", $2, $3 }''NR>2 { print $1, $1"@xyz.com", $2, $3 }' ex.csv
Output
Userid,Email Address,First Name,Last Name
jaina24,[email protected],Aayush,Jain
Rob738,[email protected],Rob,Everhard
Scorch661,[email protected],Samuel,Scorhezi
NR==1, OFS=","? And i t seems NR>2 should be NR>=2, or NR>1
NR==1 Means only line 1 and OFS returns the field seperators to , Without it, it has spaces as the delimiter. As there is no input in line 2 in this example, there is no need for >= What is the difference with announcing Nr>=2, NR>1 or even NR!=1?
Creating the Email Address field using Miller (mlr):
$ mlr --csv put '$["Email Address"] = $Userid . "@xyz.com"' file
Userid,First Name,Last Name,Email Address
jaina24,Aayush,Jain,[email protected]
Also moving the new field to the second column:
$ mlr --csv put '$["Email Address"] = $Userid . "@xyz.com"' then reorder -f Userid,"Email Address" file
Userid,Email Address,First Name,Last Name
jaina24,[email protected],Aayush,Jain
