Char format issue: à - ó

[marleygt]

Hi all!

I am new in QV and I need a little help on this situation:

The project I've done load certain data from excel; Now it happens that some words include "à" char and is reckognize as "ó".

I tryed first to use the "search" ability and I found some discussion about char format issue, but, no one fit good for my case.

Any suggestion about how to fix that?

Thank you!!

Alex

[marcel_olmo · Accepted solution]

Hi Alex,

be careful with the excel format, it depends on the current version (2003,2007,2010), and you have to specify utf8,biff or ooxml depending on the case.

Here's an example of what I'm talking about loading à and ó with different excel formats.

Regards, Marcel.

[marcus_sommer]

Maybe it's related to collation, see: Search - But what shall you find?

- Marcus

[marleygt]

Hi Marcel!

Thank you for your reply.

Ok, I think I understand clearly now.

The point is that the field including words with "à" - are already loaded inside a QVD file.

So - I suppose I should change this QVD with a new one.

I will try out this way.

Thank you.

And thanks to Marcus too. Interesting thing this "collation" to know.

I will keep in mind.

Have a nice day you both!

Alex