none
problem in exported data from system 32 Bit and 64 Bit RRS feed

  • Question

  • Hello there,

    i need some support please, as i have an issue that considered too odd somehow, I exported a PDF file from a system called "Teleopti", i exported these file from system 32 Bit once and 64 Bit once, when copy the data from 2 files then paste it with "Values and number formats" side by side, the pasted data are visually matched, but any other verification or process via VBA or logic, the data that exported from system 32 Bit, haven't any problem ever, but which exported from system 64 Bit didn't processed or verified via VBA or equations

    i uploaded the both of 2 PDF file and the pasted data in Excel sheet, need to get a concrete solution as i haven't see something like that before :),

    The ZIP file called "Export.ZIP"

    Gratefully,

      

    Monday, April 13, 2015 12:47 PM

Answers

  • "Visually match" means nothing when you try to compare strings. In the 1990th at DOS we have only 255 chars, but today we have Unicode Charset with many many chars and many of them looks equal.

    So you have to analyze your strings. e.g. with the CODE function to get the ASCII values for each char. Then you can find the issue:

    A1:  =CHAR(HEX2DEC("20"))
    B1:  =CHAR(HEX2DEC("A0"))
    C1:  =A1=B1

    Means this issue is not related to Excel, it is up to you to find your solution. E.g. a simple binary replace of Chr("A0") to Chr("20") fix it.

    But I guess that is not the only issue between the different "Teleopti" versions. It is up to you to analyze the data in details.

    Andreas.

    Tuesday, April 14, 2015 6:08 AM
  • Ahmed,

    there is no syntax or something, the issue is related to your data.

    One of your strings has an ASCII &H20 as Blank and the other an ASCII &HA0 as Blank.

    It is up to you to develop a comparison algorithm which takes into account these differences, or to manipulate the data after the import to eliminate the differences.

    Andreas.

    Tuesday, April 14, 2015 10:11 AM

All replies

  • "Visually match" means nothing when you try to compare strings. In the 1990th at DOS we have only 255 chars, but today we have Unicode Charset with many many chars and many of them looks equal.

    So you have to analyze your strings. e.g. with the CODE function to get the ASCII values for each char. Then you can find the issue:

    A1:  =CHAR(HEX2DEC("20"))
    B1:  =CHAR(HEX2DEC("A0"))
    C1:  =A1=B1

    Means this issue is not related to Excel, it is up to you to find your solution. E.g. a simple binary replace of Chr("A0") to Chr("20") fix it.

    But I guess that is not the only issue between the different "Teleopti" versions. It is up to you to analyze the data in details.

    Andreas.

    Tuesday, April 14, 2015 6:08 AM
  • Hello Andreas.

    Well, but i'm still seek to get the issue handled, i can't get the main trouble for searching in Google for a real solution.
    could you give me a searchable syntax for this problem? 

    Thanks a lot,

    Tuesday, April 14, 2015 9:34 AM
  • Ahmed,

    there is no syntax or something, the issue is related to your data.

    One of your strings has an ASCII &H20 as Blank and the other an ASCII &HA0 as Blank.

    It is up to you to develop a comparison algorithm which takes into account these differences, or to manipulate the data after the import to eliminate the differences.

    Andreas.

    Tuesday, April 14, 2015 10:11 AM