Problems with Bulk Metadata editing

[minorum]

Hi,

I need some help with regular expression and Bulk Metadate editing.
I am no programmer and have only read the calibre help for regular expressions.

I have created a new collum "genre". Now I want to search in "tags" for a given string like "crim" and if it is found the according genre in this case "Krimi" should be written in the "genre" collum.

I managed to make an regex that finds the word:
\.*crim\.*

I enterd "Krimi" in the exchange field. But what happens now is that the whole contents of the "tags" collum is copied to the new collum and only the letters "crim" are replaced bei "Krimi". But what I want is only the word Krimi in the genre collum and nothing else.

I am quite sure that it can be done. So could anyone help me and write down how this expression should look like?

many thanks

minorum

[theducks]

Originally Posted by minorum

Hi,

I need some help with regular expression and Bulk Metadate editing.
I am no programmer and have only read the calibre help for regular expressions.

I have created a new collum "genre". Now I want to search in "tags" for a given string like "crim" and if it is found the according genre in this case "Krimi" should be written in the "genre" collum.

I managed to make an regex that finds the word:
\.*crim\.*

I enterd "Krimi" in the exchange field. But what happens now is that the whole contents of the "tags" collum is copied to the new collum and only the letters "crim" are replaced bei "Krimi". But what I want is only the word Krimi in the genre collum and nothing else.

I am quite sure that it can be done. So could anyone help me and write down how this expression should look like?

many thanks

minorum

slash dot star

slash dot says look for a dot

try
.*(\,crim)\,.*
and your term in the replace field with the destination set as #genere (all custom column names start with a # )

since this original is a Tag, KISS use the Tag editor (the little recycle button on the FAR Left of the Metadata editor. Using this, removes ALL (every book) usage of the selected tag

[minorum]

Thank you.
Yes the \.* was a mistake.

The expression is was looking for was .*crim.* without the backslash
This worked but for the point that "tags" is a field with mulitble values. So only the value where the string is found will be changed. All others will be copied in the new field.

Is there a way around it?

I dont understand your hint with the tag editor. I don't wont to remove a tag. I just want to use the tags to get my collection into shape by sorting the books to genres like: science fiction, fantasy, etc.

[theducks]

Originally Posted by minorum

Thank you.
Yes the \.* was a mistake.

The expression is was looking for was .*crim.* without the backslash
This worked but for the point that "tags" is a field with mulitble values. So only the value where the string is found will be changed. All others will be copied in the new field.

Is there a way around it?

I dont understand your hint with the tag editor. I don't wont to remove a tag. I just want to use the tags to get my collection into shape by sorting the books to genres like: science fiction, fantasy, etc.

I had assumed

then simply use the Tag browser for the selection criteria (remember the any or All choice setting at the bottom).

select All, then use the Bulk metadata edit to add your value to your field.

change the criteria, repeat

[minorum]

Thanks again

Now that I read it is quite obvious - I probably was looking for something more complicated