CSharp · Console
using System;
using System.Collections.Generic;
using System.Linq;
public class Program {
public static void Main() {
var input = new List<string> {
"Location=COL&StockNumber=1111150416",
"Location=NYC&StockNumber=2222250416&Invoice=Part",
"Location=NYC&StockNumber=2222250416&Invoice=Part&Supplier=AutoZone"
};
var output = input
.SelectMany(line => line.Split('&'))
.Select(item => item.Split('='))
.GroupBy(pair => pair[0], pair => pair[1])
.ToDictionary(group => group.Key,
group => $"({string.Join(",", group.Distinct().Select(item => item.All(c => char.IsDigit(c)) ? item : "'" + item.Replace("'", "''") + "'"))})");
// Let's have a look
string report = string.Join(Environment.NewLine, output.Select(pair => $"{pair.Key,-12} : {pair.Value}"));
Console.Write(report);
}
}