Separate string into separate variables?

[JMichaelTX]

@demirtas1

If I had a variable that included these strings how could I exclude the comma and save the strings as separate variables?

A5011111, A5022222, A1102822

so that I end up with

Variable a: A5011111Variable b: A5022222Variable c: A1102822

Sometime I can have 2,3,4,5 refs in a single variable that I want to separate

Here is a macro that should work for you.
It will parse one line of one or more comma separated values (CSV) into individual KM Variables.

Parse CSV (Comma Separated Values) Line [Example]

MACRO:   Parse CSV Line [Example] VER: 3.0    2016-11-13 ~~~ DOWNLOAD: Parse CSV Line [Example].kmmacros (10.0 KB) ReleaseNotes PURPOSE: Extract One Line of CSV Data, & Set KM Variables A KM Variable will be set for each CSV Field Found RETURN list of KM Variable names and values VER: 2.0 2016-08-17 METHOD: Use JXA script to find CSV fields using: Default RegEx: (.+?)(?:, ?|$) Comma MUST immediately follow value An optional space may appear after comma RegEx for values in quotes…