[Uwe]

Hi Andras,
Thanks for your help.
Regarding the use of a semicolon instead of a comma, this did not work as the Events calendars import routine obviously cannot identify semicolons as separators.
Finally I made it by processing the data as follows:
First, I exchanged the commas between the keywords with a dummy like for example [///].
Second, I added a row before and after the row containing the keywords and filled the fields with a different dummy for each row as for example [HHHH] and [KKKK].
It´s important to have 3 different dummies to be able to exchange the right data sections later on.
Third, I saved the Excel file as CSV file and opened the csv file in an editor.
Then, I exchange all semicolons with commas, all [,HHHH,] with [,”] and all [,KKKK,] with [”,] and last but not least all [///] with [,].
That finally worked proper.
Thanks again for your support and greetings from Munich,

Uwe

PS: For all the search/replace work I only used the content in-between the square brackets.

[Author]

Posts