Anyone recognise these characters from Excel?

[Anonymous]

Hi,

We've received some data from a client using a new finance system.  It looks like some sort of encoding in the data (this is a screenshot from QlikView).  The issue is we can't see the characters in the original XLSX file we received and it only appears in QlikView.

Thoughts on what they are and how to get rid of them appreciated?

I should add it's not all lines.  Some don't have these chars.

[isingh30]

You want only middle numbers/code/name? If yes, use subfield or right/left function.

[marcus_sommer]

You could quite easily detect what special chars are included (within the excel - that they aren't displayed there doesn't mean that they didn't exists there) by using something like this:

ord(left(YourField, 1))

ord(right(YourField, 1))

and with this knowledge you could easily exclude them, for example with purgechar().

- Marcus

[atoz1158]

Another way of doing is to use the following that will only keep the upper and lower case letters plus numbers and spaces add others if you need them.

KeepChar(Field1,'ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456879 ') AS Field1

Regards

Adrian