Completed

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

Excel 2011 Macro or Mac OS Tool 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

EXAMPLE FILES:

[url removed, login to view]

[url removed, login to view]

[url removed, login to view]

[url removed, login to view]

Taidot: Excel Macros, Mac OS, XML

Näytä lisää: excel row convert text file, convert text file xml, convert text file excel file, excel to xml converter online, excel to xml converter free download, how to convert excel to xml in excel 2007, excel to xml mapping, excel to xml converter c#, xlsx to xml converter, convert to xml online, convert excel to xml format, excel, online convert text file excel, convert text file excel online, Macro convert text file excel, excel macro convert text file excel, convert text file excel format, convert text file excel file macro, convert text file excel, convert text file xml format php

Tietoa työnantajasta:
( 162 arvostelua ) Bridgwater, United Kingdom

Projektin tunnus: #16030024

Myönnetty käyttäjälle:

$30 USD 1 päivässä
(47 Arvostelua)
5.1

4 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön

$25 USD 1 päivässä
(4 arvostelua)
2.7
krishan725

I have gone through your project requirement and would like to discuss further on it. Please send me personal message for more clarification. [login to view URL] Relevant Skills and Experience Relevant Skill Lisää

$25 USD 1 päivässä
(1 arvostelu)
0.7
khanjzthanjzt

Greetings, Experienced professional, in the field of data entry and Macros. having more than 5years experience in such projects. Allow me to complete your task. Best Regards Relevant Skills and Experience Excel Prop Lisää

$10 USD 1 päivässä
(0 arvostelua)
0.0