Copy from table & paste problem

[razorking]

OK, here is a weird one, at least it seems weird to me.

I have a field on a table, or query result, doesn't matter which, and it looks like this:
"55264
"25468
"4562
"123
etc, etc.

Now I need to copy that and paste it into the notepad in Windows. When I do that the pasted data looks like this:
"""55264"
"""25468"
"""4562"
"""123"

I have looked at it on the clipboard and it also looks like the above. I really need this data to paste to the notepad just like it is stored on the table (with one double quote only). It's one of those strange sounding things, please do not ask me to explain why...I just need it like that.

Why the heck does the extra quote get added to the front and one get placed on the end?

Test it yourself and see.

Thanks

 

[razorking]

Some kind of workaround

Well I found a workaround for myself; if anyone is interested:

It looks like I can first copy it into Wordpad (or probably Word) and then copy that and paste it into notepad and it will be as I want.

 

[Ron_dK]

OK, here is a weird one, at least it seems weird to me.

I have a field on a table, or query result, doesn't matter which, and it looks like this:
"55264
"25468
"4562
"123
etc, etc.

Razorking,

Assume that he field is a Text field. Why don't change it to a number field and get rid of the ". Once you have the values like, 55264 or 25468, you can simply export it to a word document.

 

[razorking]

Well it is very difficult for me to explain why but...I actually need the double quote on the left side of the number:
"45263 (for example)

It all has to do with a business application that runs on my companies iSeries. I plan on using a macro in the iSeries Express Terminal Emulation program. My query is going to be the guts of the macro. I know what the macro must have to run and I am adding external data (which will be scanned serial numbers). These are variables that will be inserted into the macro by means of my Access query (it will be concatening certain field etc). I will run the query and copy the results and paste that into the macro (which is essentially a plain text file) in iSeries Express, then when I play back the macro it will update the location on all of the serial numbers we scanned (hundreds at a time). The format of these macro files is that the value that represents the variable (the serial number) has the double quote (") in front of it ONLY.

I told you not to ask.

It's really quite brilliant (if I do say so)

I just do not understand why it does not copy to memory exactly as it looks.