Hello to all - and Special Hello to Phil.

After squeezing my head without finding a solution I post my question:

(I posted something related here: copying the caption of different in one new image, but I can't create a script doing this process vice versa.)

I have a lot of images with IPTC headline, keywords and captions in the following format:

headline: language1 blabla blabla | language1 blabla blabla
caption: language1 blabla blabla | language1 blabla blabla
Keyword1: language1 bla1 | language1 bla2
Keyword2: language1 bla3 | language1 bla4
Keyword3: language1 bla5 | language1 bla6 etc.

This keywords look in some other applications like this (Comma separated): language1 bla1 | language1 bla2, language1 bla3 | language1 bla4, language1 bla5 | language1 bla6

One image is keyworded in two languages. The language texts in headline and caption are separated by a " | " Pipe and each language term in keywords is separated also by a Pipe.

This is a horror, cause it gives an information salad :)

I read in the Exiftool specifications on XMP, that it is possible to save separate languages in XMP fields with language code eg. -en for english. VERY nice! This is what I would like to do, but with my nixed language images.

The logic would be, that Exiftool takes an image and
1) looks in the above three fields for the " | " Pipe.
4) Then copys the the part before the Pipe to the related XMP-language1 filed and
3) then the part after the Pipe to the related XMP-language2 filed

The result would be an image file with separated languages in XMP.

Could anybody give me a hint on how to create the script for this?

Many greetings from
pixelpicker