See Sample.xml and/or Sample.json for an example file-based transformer (a.k.a. json extension and live in or below the /Transformers/ directory. Create your transformation using simple text configuration files in XML or JSON formats.
![clipmate macro for current date clipmate macro for current date](https://cdn.geckoandfly.com/wp-content/uploads/2018/11/530-clipboard-manager-windows.jpg)
![clipmate macro for current date clipmate macro for current date](https://img.yumpu.com/6786198/1/190x245/tmtm-u-controller-general-of-patents-designs-and-.jpg)
See the Help section of the application for more details. That's it! For common transformations that you use every day, you can create a shortcut macro on your desktop (or quick launch bar) to apply the transformation with a single click. To use, launch the executable, copy something into your clipboard, select the transformation(s), apply and paste. This posting is more about making the tool available for others to enjoy.
#CLIPMATE MACRO FOR CURRENT DATE DOWNLOAD#
In fact, most of the transformations that come in the download are in the XML or JSON format!Īfter using this tool for several years, and sharing with my co-workers, it seemed a proper time to share with the rest of the world. Where the real power is in your ability to write your own transformations in XML or JSON.
![clipmate macro for current date clipmate macro for current date](https://techwiser.com/wp-content/uploads/2018/03/windows-clipboard-manager-clipmate.jpg)
The Excel to SQL transformation takes the Excel input and makes it simple to paste that Excel data into a SQL #Temp table, which I can then use to import or analyze the issue. To get that into our production database on the other side of the firewall was a pain. Given I was doing that many times a day, I needed a solution, and this is that solution.Ĭonversely, I would regularly get Excel workbooks from users asking me to import/export/explain some piece of data. That's a lot of busy work just to display a table of data. After having to alter text to make it fit some need over and over and over again, I finally realized what I need to do is be able to programmatically alter the text in my clipboard without having to go to some intermediate tool.įor example, without this tool, to send results from SQL Server Management Studio to my co-worker, I would copy the results with headers, launch MS Excel, paste into Excel, format in Excel, copy from Excel, paste into the email to be sent. The most powerful one is taking an Excel sheet and transforming it into a SQL temp table script. One of my favorites is copying the top row of a SQL result set from MS SQL Server Management Studio, and transforming it into a column list to make selecting and re-arranging the columns easier. Or, splitting a string of numbers and getting a distinct, sorted subset for analysis on paste. This can be quite powerful, for example, copying a range of data in Excel (unformatted) and then transforming it into a pretty table to be pasted into an email.
![clipmate macro for current date clipmate macro for current date](https://www.excel-easy.com/smi/vba/date-time-2.png)
#CLIPMATE MACRO FOR CURRENT DATE WINDOWS#
This Windows desktop application, while running, monitors your clipboard, and allows you to alter the contents before you paste. Note: You will need to "Update Packages" to get NuGet dependencies before compiling. Download TransformClipboard Application Only (1.2M)