Convert spreadsheet rows into series of text blocks
$30-250 USD
Completed
Posted over 11 years ago
$30-250 USD
Paid on delivery
I have a spreadsheet similar to the example attached ([login to view URL]) with a list of ad units for websites.I need somebody to take this, and turn it into a series of "ad tags" (short chunks of text that contain the code that renders the ad) in a text file like in the example I've attached ([login to view URL]).
Here is the fields from the spreadsheet and where they go:
<!-- {NAME} OurCompany Canada -->
<script src="[login to view URL]">
[login to view URL]().enableSyncRendering();
[login to view URL]();
[login to view URL]().display('/28817204/{NAME}', [{SIZE_HORIZONTAL}, {SIZE_VERTICAL}], 'div-gpt-ad-{13_DIGIT_UNIQUE_NUMBER}-0','%c');
</script>
For the number, you can simply increment (for example, start at 1000000000001, followed by 1000000000002...).
You could do this by hand but I'd prefer that you do it with a simple little script to ensure accuracy. Looking for 24-48hrs turnaround.
Thanks!
Hello!
I could create a spreadsheet that will allow you to create the required text script that you could use over and over again. Please reply if interested.
Thanks,
JB