Hi, in MS docs Csv.Document a seperator is used in Text .combine, "#(cr)#(If)"
I think these are ASCII or Unicode but I can't any help in how to use them or what each means. Also what is annoying
is that whenever I type it in I get ; invalid literal, but if I copy past from stie it works, and I can't see any difference.
Text.Combine( { "A , B" , "1, firstline", "2 , secondline"}, "#(cr)#(lf)")
Csv.Document( Text.Combine( { "A , B" , "1, firstline", "2 , secondline"}, "#(cr)#(lf)"), 2 , ",")
So I would really just like direction to more information on this,
Richard.
Bookmarks