Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

No Text Delimiter Option While Importing Text/CSV Data in Power Query

  Hello,  I am trying to import Text/CSV file in Power Query, but while doing that I don't have an option to chose delimiter in the import window as it is shown in the following post response: htt...
Need Help
ronrsnfld's avatar
ronrsnfld
Super User
4 years ago

I agree that is wierd to not see the delimiter field.  A sample file that can be used to reproduce your problem might be helpful in figuring out what's going on with that import wizard.

In the mean time, why don't you just write what you think is the proper code for that file yourself?

 

To start with:

    Source = File.Contents("C:\Users\MyUserName\Desktop\123.txt"),
    ToCSV = Csv.Document(Source,[Delimiter="#(tab)"])

Of course, you can and probably should add more arguments to the Csv.Document function and add some of the other things that the wizard usually does automatically, like promoting the first row to headers and setting the data types.