Problems Pasting Into Excel With Multiple Clipboards

Questions & Suggestions
1

I have a process that's just basically:

  1. (on website) Copy 7 text fields from a website
  2. (in excel) Paste from clipboard 1 -> right key -> paste from clipboard 2 -> right key etc.

The Problem: Some values are pasted fine, some values paste a blank in the correct row and then the actual information in the row below, and some values are pasted correctly but with a blank value in the row below it (effectively erasing any information that used to be there)

My Thoughts The automation process I set up that automatically copies the items is janky so there's some junk empty space that is throwing off the formatting. Is there anyway to remove this

Is there any parallel in KBM to "pasting values only"? This might solve the problem

2

Well, managed to fix it myself. If anyone happens to be searching this in the future, this may not be the best way but what I did was just put in a "Search and Replace" after each copy and for search I copied the blank space I found in the clipboards and then replace i just did a single space.

3

I'm glad to see that you seem to have solved your own problem -- congratulations!

However, I'd like to offer a few tips for this type of workflow:

  1. Never use KM Named or Past Clipboards unless you actually need to do so
    • You need clipboards only if you need to store non plain text
    • It is faster and better to set a KM Variable to the system clipboard as soon as you have completed the copy.
  2. For use in entering the data into Excel, you can accumulate each item you copy in the same KM Variable, separated by either a TAB or RETURN, depending on how you data is structured in Excel.
    • So, for example, say you need to just enter data in adjacent cells in a row.
    • Then use TABs

In your case, if you just do a normal COPY 7 times on the web site, then a simple macro like this should work. Be sure to copy the data in the order you want it entered in Excel.
Then select the first cell in Excel to paste to, and trigger this macro.

MACRO:   Paste in Order Copied & Tab [Example]

**Requires: KM 9+   macOS 10.11 (El Capitan)+**
(Macro was written & tested using KM 9.0+ on macOS 10.14.5 (Mojave))

#### DOWNLOAD Macro File:
<a class="attachment" href="/uploads/default/original/3X/8/c/8c1ca2fc77f0337aa7976def23ff9cff110eee83.kmmacros">Paste in Order Copied & Tab [Example].kmmacros</a>
**Note: This Macro was uploaded in a DISABLED state. You must enable before it can be triggered.**




---



<img src="/uploads/default/original/3X/8/6/86155cd6ceeb6783b5096b50371d4c4ef38fe837.png" width="587" height="1178">
1 Like