[Aikanairo]

good afternoon everyone, I'm having a problem creating a template for exporting my movie library to excel.

below I report the instruction I wrote:

$ {foreach movies movie String.re}
   <Row>
    <Cell>
    <Data ss: Type = "String"> T-upload "$ {movie.path} \\ $ {movie.mainVideoFile.filename}" --thumbnail-file "$ {movie.path} \\ fanart.jpg" - -caption "
$ {movie.plot} "--to" 0.0.0.0 "
        </Data>
    </Cell>
   </Row>

I would like to be able to replace the character " which could reside in the variable $ {movie.plot}

How can I replace the character " with another character?

[Aikanairo]

please help me

[Aikanairo]

reading the documentation

https://www.tinymediamanager.org/blog/jm...-renderer/

I created a csv file, named plot.csv with the following content

"\""," "

in my .jmte file

I called the replace function

$ {movie.plot; replace (plot.csv)

unfortunately it does not take away the "from the text

could someone give me some advice?

forgive my english

[mlaggner]

this will only work from v4.1 onwards

[tars]

I think what the OP is asking is how to escape double quotes when writing a csv file for replacement.

[Aikanairo]

this will only work from v4.1 onwards

I bought version 4.1
I created the csv file called plot.csv inside the code is written like this
A, s
","
B, c

I also tried A, c

I did some simple replacement tests
in my file.jtme I called the replace function like so:
$ {movie.plot; replace (plot.csv)}

the csv file is inside tiny's data folder

[Aikanairo]

I think what the OP is asking is how to escape double quotes when writing a csv file for replacement.

no I would like to replace $ {movie.plot} by removing all the double quotes that you may encounter in the description of the movie

[Aikanairo]

i checked my version is 4.0.7 or, how do i upgrade to version 4.1? on the site gives me the opportunity to download only 4.0.7this will only work from v4.1 onwards

[tars]

For 4.1, you could try either pre-release or nightly version.

For escaping double quotes, I can only escape beginning quotes using this:

Code:

" """," "

But that doesn't work for ending quotes.

Code:

""" "," "

Looks like if it starts with two double quotes with nothing between them, it's treated like empty quotes.

[Aikanairo]

i checked my version is 4.0.7 or, how do i upgrade to version 4.1? on the site gives me the opportunity to download only 4.0.7this will only work from v4.1 onwards

this is the sample text of the variable

$ {movie.plot} =

Lorem "Ipsum" is simply a fictitious text of the printing industry and "typesetting". "Lorem" Ipsum has been the industry's "dummy standard" text since the 1500s

I added words in double quotes to make them understand my need

I would like the quotes to be replaced with a space.


$ {movie.plot; replace (plot.csv)}

this is the function I call in my .jmte file

please friend help me to open pandora box

[Aikanairo]

i checked my version is 4.0.7 or, how do i upgrade to version 4.1? on the site gives me the opportunity to download only 4.0.7this will only work from v4.1 onwards

I noticed what you say.

I don't understand why it doesn't take away the second ones too "

the character "is not unique? the replace function should eliminate all" from the text am I right? it's strange

[mlaggner]

looks like the csv parsing example I have implemented does not handle "quote only" parameters.. I will try to fix that

[mlaggner]

I've exchanged the parser lib for CSV parsing and now escaping double quotes work according to the CSV standards:

Code:

"""",

will be available in the next build

[Aikanairo]

I've exchanged the parser lib for CSV parsing and now escaping double quotes work according to the CSV standards:

Code:

"""",

will be available in the next build

Thank you very much