Text file (csv) file manipulation

I am trying to analyze some email data but lack the scripting skills to work with the source files (csv text files).

The script should be able to take two source files and build a third using content from both files.

Source files CSV_FILE1 and CSV_FILE2:

CSV_FILE1 contains information related to the user with the e-mail address "email", this includes gender, nationality and location.

CSV_FILE1 has +/- 5000 lines

Example CSV_FILE1:

email, gender, nationality, location

, "M;MEX", LOC\001

, "F;USA", LOC\001

, "F;GER", EUR\002

CSV_FILE2 is an excerpt from the email tracking logs and has sender information "email_from", date information and recipient information "email_to"

CSV_FILE2 has millions of lines (more than excel can handle)

Example CSV_FILE2:

email_from, email_to, date

, user2ATdomain,com, 09\29\2014 16:02:00

, user1ATdomain,com, 09\29\2014 16:03:00

, "user2ATdomain,com; ", 09\29\2014 16:04:00

Output CSV_FILE3

The output file should list all the transactions from CSV_FILE2 as follows:

- replace the email_to and email_from addresses with one of the fileds of CSV_FILE1 - for example nationality

- if more than one email_to is listed, split the line so that there is one transaction per recipient

Example CSV_FILE3 if I'm looking to report on "nationality":

email_to_nat, email_from_nat, date

MEX, USA, 09\29\2014 16:02:00

USA, MEX, 09\29\2014 16:03:00

MEX, USA, 09\29\2014 16:04:00

MEX, GER, 09\29\2014 16:04:00

You may suggest the best method for achieving this. Ideally it should be something that I can replicate without much effort. My environment is Windows 8. If for example this can be done with PowerShell that would be great.

I would like to have access to the script and understand it enough that I can modify it to work with different files and report on different properties. If you need more details please contact me.

Thank you!

Beceriler: MySQL, Perl, PHP

Daha fazlasını görün: excel for windows 8, windows powershell scripting, split powershell, powershell scripting, loc, email and file sender, analyze some data please, analyze some data for me, analyze some data 3, text manipulation, php split csv files, split file php script, file split php script, excel file mysql, split file, powershell php, mysql source excel, csv excel text, tracking file access, csv text file, php output csv, text sender, line csv, email content csv, php mysql access report

İşveren Hakkında:
( 4 değerlendirme ) WASHINGTON, United States

Proje NO: #6523354



Hello, I can write your script in PHP. I have done a simillar(PHP, CSV) log analysys script later. Can start working tomorrow morning. If PHP is too slow, I can make it in C++ for Visual Studio, but it will cos Daha fazlası

2 gün içinde 50$ USD
(12 Değerlendirme)

8 freelancers are bidding on average $77 for this job


Dear there I could help you now, using Powershell. And I will comment the code so you could change in future if needed Thanks & B/R

in 0 gün içinde126$ USD
(37 Değerlendirme)

Hi! I can suggest you a python code to do this task. The code will we simple and effective. Python is pretty clear and straightforward language, so you will easy understand how to edit code if needed. Contact me if you Daha fazlası

in 3 gün içinde50$ USD
(12 Değerlendirme)

hello i can do this with great perfection and timely manner as per your requirement. please discuss in message.

1 gün içinde 50$ USD
(27 Değerlendirme)

Hi we are a software development company from india in past 8 years me & my Team developed approx 950 projects for global market , we try to satisfy clients needs . we developed lots of projects for several industr Daha fazlası

in 2 gün içinde110$ USD
(5 Değerlendirme)

we would suggest using excel macro for this - should be easy for you to maintain... please share your CSV files, please reply, we can discuss further, thank you !

1 gün içinde 35$ USD
(9 Değerlendirme)

Hi how are you? Thanks for the opportunity to bid on your project. I am from the NYC area would love to discuss your project in detail. Please do take your time and visit my site [url removed, login to view] and I hope y Daha fazlası

in 3 gün içinde144$ USD
(1 Değerlendirme)

Hi, I'm writing python scripts. I think I can help you handle this task. If you're interested I can provide some more detailed design of the script. On Windows 8 python should work normaly after instalation.

in 2 gün içinde50$ USD
(0 Değerlendirme)