Thread:Chriscar2/@comment-25956839-20161212191031

Heads up, I upgraded to PowerQuery_2.39.4526.123 (64-bit) [en-us] and all my databases are broken!

The new PowerQuery takes into account carriage returns and line feeds. I've found the replace command can remove special characters, in advanced editor it looks like this (e.g.):
 * #"Split Column by Delimiter" = Table.SplitColumn(#"Added Custom","R$#(cr)#(lf)(+CRB)",Splitter.SplitTextByDelimiter("#(cr)#(lf)", QuoteStyle.None),{"R$#(cr)#(lf)(+CRB).1", "R$#(cr)#(lf)(+CRB).2"}),

On the good side Lap numbers and PR can easily be split now (split on special character), same for R$ and CRB (e.g.):
 * #"Split Column by Delimiter" = Table.SplitColumn(#"Added Custom","R$#(cr)#(lf)(+CRB)",Splitter.SplitTextByDelimiter("#(cr)#(lf)", QuoteStyle.None),{"R$#(cr)#(lf)(+CRB).1", "R$#(cr)#(lf)(+CRB).2"}),
 * #"Replaced Value13" = Table.ReplaceValue(#"Split Column by Delimiter1","—","",Replacer.ReplaceText,{"Laps#(cr)#(lf)/PR.1", "Laps#(cr)#(lf)/PR.2"}),

Another good point, carriage return and line feed can also be removed from Tier and Location e.g.:
 * #"Replaced Value28" = Table.ReplaceValue(#"Replaced Value26","#(cr)#(lf)","",Replacer.ReplaceText,{"Tier", "Location"})

I'm going to have to edit every database! But it will be worth it. Bad timing on my part, with the update due today :( 