Expression.SyntaxError: Token ')' expected

[rs87]

Not sure what I am missing here I keep getting the Expression.SyntaxError: Token ')' expected error in Power Query but can't seem to figure out where I need to fix it.

[MasonMA · Accepted solution]

Hi, please try removing your last comment-- '// Trim any excess spaces', but i'm not sure if this would give you the expected results, if not please share the sample data as well.