
Transfer Data from Excel to Txt Documents
- or -
Post a project like this- Posted:
- Proposals: 20
- Remote
- #1216776
- Awarded

Description
Description of requirements/functionality: We have extracted lots of FB Group posts and comments into a spreadsheet.
We need someone to extract our content from this spreadsheet and turn it into separate text documents.
See attached Sample doc.
Each row contains an original post and the post comments in chronological order.
In our example
Row 2 is a new Post (column C) with no comments (column G)
Row 3 is a new Post (column C) with one comment (column G)
Row 4 is a new Post (column C) with several comments (column G) from G4 down to G22
C column always contains the original post
G column always has the comment text in it
We need the Spreadsheet data extracted into text documents that contain the original post and all the follow up comments in chronological order beneath it. Thus splitting the spreadsheet into multiple text files.
The file name has to be as follows
post ID number-DATE-date of post-short-description of the post
Example (made up from attached example document)
366590396875731_503342839867152-DATE-05-02-2016-Which Title Works.txt
There are 13050 rows in the final spreadsheet, This will total approximately 900 text documents.
We would think a script would be best to handle this and we would like to have the final script as we have other documents that require this to be performed on it.
OS requirements: Windows, Linux
Extra notes:
Stuart M.
100% (20)New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Hi Stuart, Could you please clarify where would you like the "post-short-description" value to come from? As the spreadsheet doesn't seem to have such column (like for post_id or date). Also, your description states that the post comments are already in the chronological order, but having a look to the attached sample this doesn't seem to be the case (rows 14 to 17 are from 5th Feb, but rows from 18 to 22 are from 4th Feb as the rows from 4 to 13, all for the same original post). Clarifying this will be helpful in order to give you an accurate quote. Cheers, Tom
-

Hi,
I could not check 366590396875731_503342839867152-DATE-05-02-2016-Which Title Works.txt as that is not attached. I did see the attached excel file. Can you provide the sample txt file file so that I may understand exact format required?
Thanks,
Anay -

Hello
may i know how soon you want this?
2.Is job is on hourly based or fixed?
Thanks
Vishakha