Skip to main content
P
PhilippePhil
Participant
October 12, 2021
Answered

FindChangeByList.jsx + FindChangeList.txt find "√§" and replace with "ä"

  • October 12, 2021
  • 1 reply
  • 360 views

Context:

After importing text data via CSV for all "ä" characters I get a "√§" instead, "√º" instead of "ü" and "√∂" instead of "ö".

 

Problem with FindChangeList.txt:

I run the following script:

text {findWhat:"√§"} {changeTo:"ä"} {includeFootnotes:true, includeMasterPages:true, includeHiddenLayers:true, wholeWord:false} Find all umlaute and replace them correctly.

Nothing happens, all the "√§" stay the same. I tried to replace them to "ae" first and then change "ae" to "ä" in a second command but in the end it changes back to "√§".

 

Does anybody have a clue how to solve this problem?

This topic has been closed for replies.
Correct answer Manan Joshi

Resave your CSV in UTF16-BE encoding and it shall import fine. Also do make sure that after resaving the csv with new encoding remove the data source and reimport it. I see InDesign detects that the csv link is to be updated but updating the link does not reflect the changes, in fact the update status is not removed from links panel so the only way I could achieve the refreshed results was reimporting the data file

-Manan

1 reply

M
Community Expert
Manan JoshiCommunity ExpertCorrect answer
Community Expert
October 13, 2021

Resave your CSV in UTF16-BE encoding and it shall import fine. Also do make sure that after resaving the csv with new encoding remove the data source and reimport it. I see InDesign detects that the csv link is to be updated but updating the link does not reflect the changes, in fact the update status is not removed from links panel so the only way I could achieve the refreshed results was reimporting the data file

-Manan

-Manan
    P
    PhilippePhilAuthor
    Participant
    October 13, 2021

    Thank you for your help! It works perfectly fine now.

    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices