Paste comma separated list with tab key between each item

Return to ClipboardFusion Macros

Description	This macro will take a comma separated list, and for each item, it will paste, then press the tab key.
Language	C#.net
Minimum Version	5.9.1+
Created By	Keith Lammers (BFS)
Contributors	-
Date Created	Feb 24, 2022
Date Last Modified	Mar 10, 2022

Macro Code

Copy

Select All

using System; using System.Collections.Generic; // The 'text' parameter will contain the text from the: // - Current Clipboard when run by HotKey // - History Item when run from the History Menu // The returned string will be: // - Placed directly on the Clipboard when run as a Macro // - Ignored by ClipboardFusion if it is 'null' // - Passed along to the next action in a Trigger (null changed to an empty string) public static class ClipboardFusionHelper { public static string ProcessText(string text) { // Split the comma separated items out to an array string[] splitItems = text.Split(','); // Loop through the items foreach (string item in splitItems) { // Paste the item BFS.Clipboard.PasteText(item); // Short 100ms wait BFS.General.ThreadWait(100); // Send the tab key BFS.Input.SendKeys("{VK_9}"); // Short 100ms wait BFS.General.ThreadWait(100); } return text; } }