Print

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

[Phydeaux]

I am trying to create an expression column to use "AtomicParsley" to add the relevant tags that J River finds to the mp4/m4v files so that they can be imported into iTunes and be viewed on my Apple TV.

I have the following expression:

Code: [Select]

AtomicParsley.exe "[Filename]" --genre "TV Shows" --stik "TV Show" --title "[Name]" -H "[Series]" -I "S[Season]E[Episode]" -U [Season] -N [Episode] --description "[Description]" --overWrite
The thought is that I can then extract this information and run it from the command line. It works except for the 'Description' field which occasionally contains new lines characters. Is there any way to get rid of these? I imagine that the "Replace(...)" function is what I'm looking for, but can't figure out how to search for a newline character.

Any suggestions?

Philip

[MrC]

Try using the Clean() function.  It will replace newlines and other unprintables with a space character for each.

[Phydeaux]

Unfortunately, that also removes a number of other useful characters, such as a ?. I will copy and paste to Excel for now and use some creative filtering.

[MrC]

Since you're doing this to produce essentially a command line, let me suggest instead that you build your command line in a command line environment.  Use MCWS to obtain the field values you want.  In that environment, you can use whatever tools you want to massage the data.

For what I think you're doing, I'd use perl or Cygwin.

[MrC]

It also occurred to me later you could use Hexify().  It will convert newlines into hex values safe for URLs.  It will convert other characters too, but you can change them back.  For example:

   replace(
       replace(
          Hexify([description]),
       %20, / ),
   %3F, ?)