Closed

Pull specific information from metadata in a file and output to excel format

I am working with a file that has various information I would like to extract and format out to an excel file. The file ends in .dta and contains information such as:

(

'far_filenamev4'

(

'name'

"Song Name"

)

(

'artist'

"Artist Name"

)

('master' 1)

(

'song'

(

'name'

"songs/far_allthatshewants/far_allthatshewants"

)

(

'tracks_count'

(2 2 2 2 2 2)

)

(

'tracks'

(

(

'drum'

(0 1)

)

(

'bass'

(2 3)

)

(

'guitar'

(4 5)

)

(

'vocals'

(6 7)

)

(

'keys'

(8 9)

)

)

)

(

'pans'

(-1.00 1.00 -1.00 1.00 -1.00 1.00 -1.00 1.00 -1.00 1.00 -1.00 1.00)

)

(

'vols'

(0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00)

)

(

'cores'

(-1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1)

)

('vocal_parts' 3)

(

'drum_solo'

(

'seqs'

('[login to view URL]' '[login to view URL]' '[login to view URL]' '[login to view URL]' '[login to view URL]')

)

)

(

'drum_freestyle'

(

'seqs'

('[login to view URL]' '[login to view URL]' '[login to view URL]' '[login to view URL]' '[login to view URL]')

)

)

(mute_volume -96)

(mute_volume_vocals -12)

(hopo_threshold 170)

)

('song_scroll_speed' 2300)

(

'bank'

"sfx/[login to view URL]"

)

(drum_bank sfx/[login to view URL])

('anim_tempo' 32)

('song_length' 216602)

('preview' 32000 62000)

(

'rank'

('drum' 124)

('guitar' 139)

('bass' 181)

('vocals' 132)

('keys' 153)

('real_keys' 211)

('band' 165)

)

('genre' 'popdanceelectronic')

('vocal_gender' 'female')

('version' 30)

('format' 10)

('album_art' 1)

('year_released' 1993)

('rating' 1)

('sub_genre' 'subgenre_dance')

;ORIG_ID=far_filenamev4

;ORIG_ID=1000000242

;ORIG_ID=1000000051

('song_id' 1000000240)

('tuning_offset_cents' 0)

('guide_pitch_volume' -3.00)

('game_origin' 'ugc_plus')

('encoding' 'latin1')

(

'album_name'

"This_Album_Name"

)

('album_track_number' 2)

I would like the following information extracted out to columns / rows an excel file.

Column names:

Artist Name, Song Title, Instrument Type (Guitar, Bass, Keys, Vocals, Drums, Pro Guitar, Pro Bass, Pro Keys, Pro Drums, Harmony Vocal)

I can assist with how to determine each instrument type listed for the columns, looking for some quick assistance with setting this up.

Skills: Audio Production, Audio Services, Data Entry, Excel, Music

See more: vba word output excel file, save scipt output excel file, convert dat file excel format, adobe bridge metadata export csv', extract metadata to excel, export file metadata to excel, export adobe bridge metadata to excel, export image metadata to excel, extract metadata from word document, metadata extraction tool, export metadata to excel, php, excel, python, output excel file php, quick pull information xml file, convert word file excel format, dat file excel format, excel file output php, oracle report output excel format

About the Employer:
( 16 reviews ) Grand Rapids, United States

Project ID: #17535288

27 freelancers are bidding on average $26 for this job

sajibdigital

Hi I can help you. I am expert in Excel. Please contact me for more discussion. I am waiting for your message on my inbox. thanks

$30 USD in 1 day
(68 Reviews)
5.7
mariusalex86

Hello. I am interested in this project and I would like to receive more details. Just for one file? I am a reliable freelancer, focused on quality and accuracy. Kindly consider my proposal. Thank you.

$20 USD in 1 day
(68 Reviews)
5.6
uhjk

Hello, I can create php script to extract data as you want. It will take 1-2 hours to complete. Thank you.

$25 USD in 1 day
(53 Reviews)
5.8
vmadhavan15

am not a random bidder.. please ping me if you are intereste with my proposal and share more details.. thank you..

$100 USD in 1 day
(9 Reviews)
4.2
$25 USD in 1 day
(17 Reviews)
3.4
$30 USD in 3 days
(10 Reviews)
3.6
nazlicansari

Hi, I am looking forward to hearing from you at your earliest convenience. Thank you for your time and consideration!

$20 USD in 2 days
(3 Reviews)
1.6
nidhi123jayani

I am expertise in Web Editing, Designing web pages as well blog , post, posters, templates. I have excellent experience in excel with Microsoft office. As I am an IT engineer and working as QA Automation . I am intere More

$25 USD in 1 day
(0 Reviews)
0.0
Datalogo

I'm good at that job Relevant Skills and Experience Freesher

$25 USD in 3 days
(0 Reviews)
0.0
$30 USD in 2 days
(0 Reviews)
0.0
sergeyshishkin

Hello! Suppose that this file was created with Stata. There is a way to convert it using Python language. Please check my profile page, to find out if we can work together. It seems that adding many text in bid, More

$25 USD in 1 day
(0 Reviews)
0.0
andersenshawn

I have experience working with large amounts of files for extraction in both Python and excel. Also have knowledge of working with wav and midi music files on personal projects and am knowledgeable regarding their meta More

$20 USD in 2 days
(0 Reviews)
0.0
sunnynur71

Hi there! I'm interested to help you on the project that you posted, I've done a few excel jobs before and can show you. Thanks.

$10 USD in 1 day
(0 Reviews)
0.0
$30 USD in 1 day
(0 Reviews)
0.0
$25 USD in 1 day
(1 Review)
0.0
okwirpeter23

Hi I am Peter. An accurate and fast typist. I have work songtrader doing the similar job. I've got experience to get this job done. Would be pleased to work with you

$25 USD in 1 day
(0 Reviews)
0.0
vAlenav

Hello I understand what you need to be done Can you send me the file with metadata? How to determine instrument type? Can start immediately

$25 USD in 1 day
(0 Reviews)
0.0
mayeck

me gustan los retos y me gusta trabajar en excell, si me transmites la información hago un excelente trabajo para que el cliente quede satisfecho

$30 USD in 3 days
(0 Reviews)
0.0
$25 USD in 2 days
(0 Reviews)
0.0
$30 USD in 3 days
(0 Reviews)
0.0