UNIX for Dummies Questions & Answers

Hello everyone. I'm new to the boards, I hope I can get and possibly give some help through these forums.

I need some help.
I have two CSV files, let's call them File A and File B.

This is the structure for File A:
ID, VAR1, VAR2, VAR3 - VAR50 (where the VAR 1-VAR50 are either 0 or 1)

This is the structure for File B:
ID, GENDER (where GENDER is either 0 or 1)

I want to do is create 2 additonal files, File C and File D. The file needs to be the same structure and have the same number of records as File A (ID, VAR1-VAR50). But for File C, I want VAR1-VAR50 to be set to missing (in this case a space) for all men. And for File D I want VAR1-VAR50 to be set to missing for all women.

Can anybody help me with this? Does my question make sense?

Thanks in advance for any help.

Try this one and next time, please provide with your sample file and desired output for better understanding of your problem...

Code:

awk -F, 'NR==FNR{_[$1]=$2;next}$1 in _ {
if(_[$1]==0) {print > "File_C"}
else{printf $1 FS > "File_C"
for(i=1;++i<=NF;){$i="" FS; printf (i==NF?$i RS:$i FS) > "File_C" }}}'  File_B File_A

And i hope you can figure it out for File_D.