Hi all,
i've to convert many text files. The content of each file should be imported to a Database.
Files Content appears like this:
# 03 Bonnie and Clyde (by ?) - Jay-Z feat. Knowles, Beyonce [#11]
# 2+2=5 (by ?) - Radiohead [#31, 2003/04]
# All about lovin' you (by ?) - Bon Jovi [#28]
# All I have (by ?) - Jennifer Lopez & LL Cool J. [#15]
# All in my head (by ?) - Kosheen [#34]
# All my life (by Foo Fighters) - Foo Fighters [#44, 2002/03]
where
% mean a new record to be created
containing five fileds in this order
TrackName (from the % at every newline to '(' character)
Written By (from '(by' to ')' ... if the value is '?' it should be set to 'blank' or 'empty')
Artist (from ' - ' to ' [' or the end of the line )
Featuring (if in Artist Field there is 'Feat. someone' it should be moved from artist to featuring field )
Info (from '[' to ']' if existent)
Now ... this is a really big question.
Is there a tool to do this via commandline?
and if yes, which ?
I need only that the tool is able to parse the input text file and write to standard output as tab delimited
Please help ...
i've millions of files to process with thousands entryes... i don't like to do this manually .... i really need help ... if someone has a tip ... i'll be very grateful !
Thanks in advance
i've to convert many text files. The content of each file should be imported to a Database.
Files Content appears like this:
# 03 Bonnie and Clyde (by ?) - Jay-Z feat. Knowles, Beyonce [#11]
# 2+2=5 (by ?) - Radiohead [#31, 2003/04]
# All about lovin' you (by ?) - Bon Jovi [#28]
# All I have (by ?) - Jennifer Lopez & LL Cool J. [#15]
# All in my head (by ?) - Kosheen [#34]
# All my life (by Foo Fighters) - Foo Fighters [#44, 2002/03]
where
% mean a new record to be created
containing five fileds in this order
TrackName (from the % at every newline to '(' character)
Written By (from '(by' to ')' ... if the value is '?' it should be set to 'blank' or 'empty')
Artist (from ' - ' to ' [' or the end of the line )
Featuring (if in Artist Field there is 'Feat. someone' it should be moved from artist to featuring field )
Info (from '[' to ']' if existent)
Now ... this is a really big question.
Is there a tool to do this via commandline?
and if yes, which ?
I need only that the tool is able to parse the input text file and write to standard output as tab delimited
Please help ...
i've millions of files to process with thousands entryes... i don't like to do this manually .... i really need help ... if someone has a tip ... i'll be very grateful !
Thanks in advance