0

I have a problem with a Google Sheet.

I use docpaser to read incoming pdf files - doc parser reads 8 pieces of information in each pdf file and adds a new row to a Google Sheet with the information in 8 columns (A:H).

Its working excellent - however in a text column (C) I have a problem.

Due to language (Danish) we have 3 extra letters Æ Ø Å wich the docparser don't read and send correct to the Google Sheet row.

Only if there is either a Æ, Ø or Å there is a problem.

each letter Æ, Ø or Å is wrongfully read/added to the Google Sheet row, ex:

Æ: Ræv is added as Ræv - I need to the sheet to automaticical replace "ø" with Æ Ø: "Brød" is added as BrÃÂd - I need to the sheet to automaticical replace "ø" with Ø Å: "Råd" is added as RÃ¥d - I need to the sheet to automaticical replace "Ã¥" with Å

I know I can manipulate it via formulas, but I would like to avoid making extra colums in the sheet and have this done automatically when a row is added (without to run a manual macro ect - if possible.

Thanks in advance for your input, Casper

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.