Let me choose Decimal separator and Date order in PowerQuery instead of guessing
When importing textfiles using Get and Transform I always struggle with one thing: I do not know upfront what the decimal separator and date order is of my text file. PQ only offers to choose a Locale, but it does not tell me what date order and syntax, nor which decimal separator belongs to this locale.
I'd love to be able to just choose the relevant separators and date order from a couple of drop-downs. I can almost always see which it is I need from the data, but I hardly ever know which locale belongs to the specific combination of separators in the file I happen to be looking at at the moment.
I agree with Jan Karel
Ton Knijnenburg commented
I agree, saves a lot of annoying puzzeling.
absolutely agree on this topic, saves us a lot of clicks
Jeff Carno commented
This would save so much time and annoyance. Clearly, someone missed this during the design of the interface.