Link to home
Start Free TrialLog in
Avatar of Rob4077
Rob4077Flag for Australia

asked on

Why do two PC's have differences when importing the same data from the clipboard

I have written a routine that imports data from the clipboard into a database. I have run the exact same source data on two machines, both running Access 2007 and the data comes in differently. The difference appears to be that one is copying data from data viewed Internet Explorer and the other is using Mozilla Firefox. The difference is the way they handle a few characters. For example in one place i.e. brings in
chr(13) chr(10) chr(13) chr(10)
a pair whereas Firefox only reads
chr(13)&chr(10)
a single set.

In other places i.e. imports chr(32) whereas Firefox imports it as chr(9)

In another place Internet Explorer imports chr(32) chr(13) chr(10)
whereas firefox imports
chr(13) chr(10)

These differences make it difficult to consistently import data. Can anyone suggest how I can get around these problems given I need to substring the data meaningfully to populate fields and tables
Avatar of Randy Downs
Randy Downs
Flag of United States of America image

make your default browser teh same on both PCs
Avatar of Rob4077

ASKER

That would fix it but I was hoping to be able to handle both.
ASKER CERTIFIED SOLUTION
Avatar of Randy Downs
Randy Downs
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Rob4077

ASKER

Thanks. That's basically what I had to do. I was hoping there might be a setting somewhere that made it easy.
<I have written a routine>
... Ok, so can you post the code for this "Routine" for us to evaluate?

<...that imports data from the clipboard into a database.>
What "Specifically" are you importing...?
(Give a specific example)

Using the clipboard is sometimes an unreliable way to transfer data...

Like Number-1 suggests, if the only thing stopping this from functioning consistently is users using the same browser, ...then tell them to use the same browser...
;-)
(at least when doing this specific transfer).
Just tell users:
"In order to do the ____ Transfer, you must be in FireFox"

Chr(32) is a Space character, so I am not quite sure why one browser would see it and another would not...

Anything can be done, but without seeing your current code we can't suggest anything specific.
In an overall sense, you would probably need some If-Then logic:

If Firefox then
    ....
ElseIf IE then
    ....
End if

JeffCoachman
Avatar of Rob4077

ASKER

Hi Jeff,
Thanks for your clarification. I have now written some code that simply replaces a few character strings to make them consistent across both platforms and then continues processing so its done.

I am surprised that the same data coming from a server to a client is actually changed (although it appears visibly identical). I would have thought that what the server sends the client displays unchanged. For that reason I asked the question hoping there would be some setting that would fix the problem. At any rate it's all fixed and working on both platforms for now.