Hi @reblrebl!

One idea I have is that (assuming that your individual pieces of data don’t have commas in them) you could split at the comma, and as your output choose the line item option. Then you run all the line items through another split text that will use the : as the separator. But at this point you’ve already used 3 Formatter steps and you may need to use another one in order to get things the way you need them for Google Sheets.

You could see if sending those emails to an email parser would be a better option, or if you know any developers, this could likely be done with a Code step. We have a few developers who hang out in the Community. For example, @ikbelkirasan, have you got any Code step ideas here that wouldn’t be super complex?

@nicksimard - Sure, thanks for the mention!

@reblrebl - You might want to try the following JavaScript code snippet. You should map the string you want to parse to an input field called input. 

const { input } = inputData;
const regex = /(=^:,]+):\s+((.(?<!\s,))+)/g;
let m;
const matches = {};
while ((m = regex.exec(input)) !== null) {
  if (m.index === regex.lastIndex) {
    regex.lastIndex++;
  }

  const n, key, value] = m;
  matchesckey.trim()] = value
    .trim()
    .replace(/&nbsp;/g, " ")
    .replace(/&euro;/g, "€");
}

output = pmatches];