detroitger.blogg.se

Import comma delimited file into excel
Import comma delimited file into excel







import comma delimited file into excel import comma delimited file into excel

ReplaceQuote = Table.ReplaceValue(Source,"'","""",Replacer. Source = Csv.Document(File.Contents("C:\Test\commas.txt"), ), On first step instead of Load click transform, in formula bar modify first step of the query as import without delimiter, after that replace single quote on double one and split column with comma as delimiter. You may modify a script a bit from user interface. I don't know the way to define single quote as text qualifier. Then select comma as the delimiter and hit finish Share Improve this answer Follow answered at 20:44 Raystafarian 21.5k 11 60 90 71 And you have to do that every time after double-clicking. text like "something","company, inc",1,2,3 Go to the Data tab and select text to columns under data tools then select delimited and hit next. If import by default From Text/CSV it recognises double quote as text qualifier, i.e. On the second step of the wizard select single quote as text qualifier To switch it on File->OptionsĪnd use it from Data->Get data->Legacy wizard.

import comma delimited file into excel

You may use legacy file import wizard which is switched off by default.









Import comma delimited file into excel