How to change dafault option of Text Import Wizard?

  • Thread starter Thread starter Dragon
  • Start date Start date
D

Dragon

When importing a data from file,

Raw data :
TestID 00001770 11:05:49 8275.75 0.726376
TestID 00001771 11:05:53 8293.84 0.72549
TestID 00001772 11:05:58 8291.29 0.724395
TestID 00001773 11:06:03 8283.01 0.735552
TestID 00001774 11:06:07 8264.74 0.717463
TestID 00001775 11:06:12 8241.47 0.697707
TestID 00001776 11:06:17 8270.08 0.696421
TestID 00001777 11:06:22 8300.33 0.709703
TestID 00001778 11:06:26 8335.09 0.76689
TestID 00001779 11:06:30 8335.74 0.762716
TestID 00001780 11:06:36 8313.61 0.760062

But, what I just need is fourth column of each row, such as 8275.75, 8293.84

Then I use the functions as below.
Data --> Get External Data --> Import Text File
then I selected file and Text import Wizard 1 step shows up.
My question is here. I want to choose 'Delimited' option, but all the time
text import wizard is opened, the dafault is selected on 'Fixed width'.

Anyone knows how to change these default?
 
I don't think you can change the default.

But I don't think I'd do that even if it were possible. Since your data is laid
out consistently and you always want the same portion, why not record a macro
when you import the data.

Then the next time you need to import the data, you can just run that macro
again.
 
Back
Top