How to decode &#xE9, ? ‍♂️

[KJZenno]

Hello community,

First of all, thank you for all the help i found on the forum as a simply visitor.

But today, i am struggling with a decoding probleme.

I scrape a French website and I get some encoded characters on a gsheet! I already used the bloc text processing / decode / UTF-8 but it doesn't work.

In exemple,
I scrap :
- Chef gérant H/F CDI => Zenno pastes in Gsheet "Chef g&#xE9,rant H/F CDI"
- Chef Pâtissier H/F CDI => Zenno pastse in Gsheet "Chef P&#xE2,tissier H/F CDI"
- ect...

Do you have an idea to solve this problem ?

Thanks a lot for your help,

 

[VladZen]

Hello community,

First of all, thank you for all the help i found on the forum as a simply visitor.

But today, i am struggling with a decoding probleme.

I scrape a French website and I get some encoded characters on a gsheet! I already used the bloc text processing / decode / UTF-8 but it doesn't work.

In exemple,
I scrap :
- Chef gérant H/F CDI => Zenno pastes in Gsheet "Chef g&#xE9,rant H/F CDI"
- Chef Pâtissier H/F CDI => Zenno pastse in Gsheet "Chef P&#xE2,tissier H/F CDI"
- ect...

Do you have an idea to solve this problem ?

Thanks a lot for your help,

What's the real phrase on the website? without encoded characters?

 

[KJZenno]

What's the real phrase on the website? without encoded characters?

The real phrase on the website is "Chef gérant H/F CDI " and Zenno pastes in Gsheet "Chef g&#xE9,rant H/F CDI"