Cancelled

Mac OS Tool or Excel 2011 Macro to convert text file to XML files

Mac OS Tool or Excel 2011 Macro to convert text file to XML files

Please see the enclosed input file:

Popmaster Quiz Week 1

This is a text file with a tab delimited playlist. Using the information stored in the file we must create three new files.

1) Popmaster Quiz Week [url removed, login to view]

The <title> will be populated from the name of the input file.

The <long_answer> will be populated from the "Name" tab in the input file. No other changes are required to this file.

2) Popmaster Quiz Week [url removed, login to view]

The <title> will be populated from the name of the input file.

The <long_answer> will be populated from the "Name" tab in the input file.

The <short_answer> will be populated from the first letter of the "Name" field in the input file. Except where the first word is "The", then it will be populated from the first letter of the second word in the "Name" field in the input file.

3) Popmaster Quiz Week [url removed, login to view]

FileDuration will be populated from the "Time" tab in the input file.

FileLocation will be populated from the "Location" tab in the input file, making sure to replace : with / and also removing the initial Macintosh HD

FileStartTime will remain unchanged at 00 : 00 . 0

FileTitle will be populated from the "Name" tab in the input file.

Artist will be populated from the "Artist" tab in the input file

Edited will remain unchanged at false

FileType will be "audio" for mp3 files and "video" for mp4 files.

Selected will remain unchanged at false

SudPlay will remain unchanged at true

Attachments are not being displayed for some reason?

https://www.dropbox.com/s/gn3vt2si45ms75c/Popmaster%20Quiz%20Week%201?dl=0
https://www.dropbox.com/s/cnrynlcokuv7ehg/Popmaster%20Quiz%20Week%201.sqb.xml?dl=0
https://www.dropbox.com/s/kd1kd2nbim2ea2n/Popmaster%20Quiz%20Week%201.sqq.xml?dl=0
https://www.dropbox.com/s/4er57di559psjaj/Popmaster%20Quiz%20Week%201.xml?dl=0

Habilidades: Excel Macros, SO Mac

Ver más: how to convert excel to xml in excel 2007, mac excel vba open file, excel to xml converter online, excel to xml converter free download, convert to xml online, xlsx to xml converter, excel to xml mapping, convert excel to xml format, convert text file xml, convert text file xml format php, convert text file xml free program, php convert text file xml file, convert text file html vba sql access, convert text file rss, convert text file rss files, loading text file xml, convert text file database mysql php, convert autocad file xml, convert text file rss feed, convert text file rss file

Información del empleador:
( 162 comentarios ) Bridgwater, United Kingdom

Nº del proyecto: #16029869