search

mogulargmbh / m-formatter

23 stars 3 forks source link

Cleaning undesirable (#lf) in the ODBC string #18

Open rfeldhaus opened 1 week ago

rfeldhaus commented 1 week ago

Description I try to use the formatter to rewrite an ODBC sql query, but the formatting is not as desirable

Power Query- / M-Code let Source = Odbc.Query("dsn=DenodoODBC", "SELECT #(lf) #(lf) ""Company EDC ID"",#(lf) ""Company Name"",#(lf) ""Activity ID"",#(lf) ""Activity Type"", #(lf) ""Activity Description"",#(lf) ""Activity Status""#(lf)#(lf)#(lf) FROM admin.ei_sales.sales_activities") in Source

Expected behavior let Source = Odbc.Query("dsn=DenodoODBC", "SELECT ""Company EDC ID"", ""Company Name"", ""Activity ID"", ""Activity Type"", ""Activity Description"", ""Activity Status"" FROM admin.ei_sales.sales_activities") in Source

Settings Special configuration settings you possibly used to call the formatter.

UliPlabst commented 1 week ago

Hello, thank you for raising this issue. I am on holiday now and will be back at the end of July then I will look into this issue.