Clipboard Copy

[k005]

Hi All,

578.6
25.6
603.9
715.6

In this way, how can I select numbers (Text) objects and transfer them to the Clipboard in the same order?, replacing the dots with commas and adding the expressions equal and /1000 to the memory in the same order.

=578,6/1000
=25,6/1000
=603,9/1000
=715,6/1000

* Doslib is installed on my system...

[komondormrex]

select texts, sort 'em down Y, make of 'em required mtext and copy mtext textstring to the clipboard either way.

[hak_vz]

@k005 

1)  use command strcat on each on text segments to add = and / 1000

2) use vl-string-subst to convert comma symbol

3) use command (express tool) TXT2MTXT to convert all texts to single multi-line mtext object

4) enter mtext edit mode, select all texts and copy to clipboard to transfer to other programs or whatever you need.

Steps 1 to 3 are lisp coded in 3 lines of code.

It's time to see your code. Can be done in no more than 3 lines of code.

[k005]

@komondormrex 

@hak_vz 

Thank you.

[k005]

**************************** THIS ISSUE HAS BEEN RESOLVED.  C# *****************************

[Sea-Haven]

After copyclip what then to Excel ? You can write to the clipboard so no need to use the pick text and copy. 

Ok to paste into excel as separate cells need something like this note the Cr.

(setq str (strcat "A" (chr 13) "B" (chr 13) "C" (chr 13) "D"))
(vlax-invoke
    (vlax-get (vlax-get (vlax-create-object "htmlfile") 'ParentWindow) 'ClipBoardData)
    'setData
    "TEXT"
    str
)

 Mtext will give A\PB\PC\PD in one cell, similar with using \n.

[k005]

Thanks for the suggestion.

This was about pasting the result obtained by dividing the weights in the iron quantity by 1000 into Excel. I managed to add it as a parameter to a section in my program that I prepared before.