Hi there, I was wondering if someone could help me with this. I have two variables each storing two separate lists. the stored info in variable 1 is: 1,79,347,3 2,82,390,3 3,82,433,3 4,79,476,3 5,82,519,3 6,82,562,3 7,82,605,3 8,82,648,3 and variable 2 has: 74,211,1 74,227,1 74,243,1 7…

Hi Billy, A similar question was posed and answered here: [image] Easiest way to align 2 collections Questions & Suggestions What would be the easiest way to align 2 collections like: First item Second item Third item and: Bird Horse Plant Leading to the desired r…

beautiful, thank you, thats exactly it.

and in JS, perhaps: Columns from two variables.kmmacros (19.5 KB) [twoCols] (() => { 'use strict'; const main = () => { const kme = Application('Keyboard Maestro Engine'), strTwoCols = unlines( zipWith( (x, y) => x + ','…

Interesting (to me): The use case looks like restructuring a CSV file. Is it? Which leads to my thought that some macros to manipulate CSV - such as deleting columns, inverting a CSV etc would be handy.

My personal first choice (for writing such things) would be the Python CSV reader module (See, for example Trying to parse csv file into variables ) ( I first met it when I had to process a 4Gb CSV file in an unexpected hurry – to my surprise it worked perfectly for that, and has always served well…

Hey Billy, Give this a try. -Chris Align Two Colums of Data v1.00.kmmacros (5.7 KB) [image]

Tho even AppleScript could probably manage it :wink: -- commaJoined :: String -> String -> String on commaJoined(x, y) x & "," & y end commaJoined on run tell application "Keyboard Maestro Engine" set strFirst to getvariable ("firstCol") set strSecond to getvariable ("secon…

Thanks. I have some experience with Python’s csv module. Choreographing it with KM would be the novel bit. I’m wondering how to pass selected text into a Python module as a string - using KM. I should experiment.

So THIS got me there: https://stackoverflow.com/questions/29722041/passing-keyboardmaestros-variable-to-python-script#29722626 I just need to do the CSV stuff. Next stop is “put first column of CSV on clipboard back on clipboard” - as a simple example.

I have a vague recollection (Peter will know) that there can be UTF8 limitations with reading KMVars through os.environ. The other thing is, of course, to write out to a temporary file, and get Python to read that. My JSA Action staples for those things include: // filePath :: String -> FilePath …

Keyboard Maestro Discourse

Merging two variables line by line

Questions & Suggestions

MartinPacker May 30, 2018, 7:53pm 14

Here's the macro I mentioned: “Select CSV Columns” Macro

Certainly I'll take improvement suggestions. But I'm likely to move onto the next CSV manipulation challenge soon.

Merging two variables line by line

Options