Print

Please login or register.
1 Hour 1 Day 1 Week 1 Month Forever
Login with username, password and session length

[ted_b]

Success!  Thanks   

[ted_b]

One question has come up, and I've done a search and found a very similar thread, but the answer (log expression) doesn't seem to work. 
.....the expression was =listitem( [composer],listcount([composer],/ ),/ )

So here goes:

The label wants to name the files with the composer last name in the file name.  The composer tag has two to three names in it (meaning Amadeus Mozart or Ludwig Von Beethoven) but last name is always, er, last, and is preceded by a space.  Is there any expresssion I could use to strip off just the last name (for the file renaming) or should I simply do edits to the tags and make a new composer-last-name field (filled with copy and pasting from composer data)?  Thanks
Ted

[MrC]

Sure, but also consider: What is the last name of these:

   - Cipriano de Rore
   - Michael Tilson Thomas
   - Lara St. John
   - Jaap van Zweden
   - Manuel de Falla

If you truly want just the last "word", then:

   regex([composer], /# ([^ ]+)$#/, 1)

[ted_b]

Very good point.  I just got off a conference call, and we are fixing the data.  Thanks!

[ted_b]

Mr C, need a hopefully simple issue addressed.  Some of the small labels are sending Jared (Channel Classics) some of their own spreadsheets (we've successfully done his, several hundred, thank you again...), which I've taught him to move into CSV's, etc.  I have his perl running fine, TEXT-CSV installed, etc.  Howver, we keep getting this error message (and the mpl is created with nothging in it)
"No such file or directory at csv2mpl.pl line 18"  .  ??  Line 18, if I am correct, is looking for the music files?

[MrC]

The error is stating that the file being passed on the command line is not correct or does not exist.  It should be a relative or full path to a CSV file.

[ted_b]

Thanks for the response.  So you are saying that the script can't find the csv?  And the basepath location?  That is where the yet-to-be-tagged music files should be located, right?

[MrC]

Your summary seems correct.

[ted_b]

Thanks.  I teamviewed in to Jared's pc and tried a few things but none seem to work.  On a side note, the csvs he produces (Danish version of Excel) are semi-colon delimited!  Argh.  I fixed them, so this is not the issue, but it's another hurdle regardless.

[MrC]

See if the same path does not work with any other command, such as:

   more path-to-CSV

If not, what path are you specifying?

[ted_b]

mid of the night in Europe now, so will get on his pc again in am.  The path is nothing weird; it's like
perl csv2mpl.pl X:\dsf_csv\COBRA0036.csv >COBRA0036.mpl
where COBRA0036 is the name of the csv (as well as the name of the catalog # tag), and the files (in the basepath) are named like 01-COBRA0036.dsf, etc.