How to skip the first line of a text file when reading it?
330 次查看(过去 30 天)
显示 更早的评论
I have a file like this:
- DQ20091222000002.txt
- 2009-12-22 00:00:02--2009-12-23 00:00:12
- 3.4814
- 3.4814
- 3.4766
- 3.4814
I do not need the first two lines. How to skip them? By the way, the number list is extra, not included in my file.
1 个评论
Harsimran Singh
2021-5-3
use this link, it works perfectly for me:
Option Explicit
Sub FixCsvFiles()
Dim SelectFolder As String
Dim csvFiles As Variant
Dim csvWb As Workbook
Dim x As Integer
'browse for folder with csv files
On Error GoTo FixCsvFiles_Error
SelectFolder = GetFolder("c:\")
Application.ScreenUpdating = False
'Check user did not cancel folder selection
If SelectFolder = "" Then
MsgBox "No Folder Selected - Cannot continue", vbCritical
End
End If
SelectFolder = SelectFolder & "\"
csvFiles = Dir(SelectFolder & "*.csv")
Do While csvFiles <> ""
Set csvWb = Workbooks.Open(SelectFolder & csvFiles)
Rows("1:2").Delete
x = x + 1
csvWb.Close True
csvFiles = Dir
Loop
Application.ScreenUpdating = True
MsgBox "A total of " & CStr(x) & " files processed", vbInformation
On Error GoTo 0
Exit Sub
FixCsvFiles_Error:
MsgBox "Error " & Err.Number & " (" & Err.Description & ") in procedure FixCsvFiles of Module2"
End Sub
Function GetFolder(strPath As String) As String
Dim fldr As FileDialog
Dim sItem As String
Set fldr = Application.FileDialog(msoFileDialogFolderPicker)
With fldr
.Title = "BROWSE TO FOLDER LOCATION WITH CSV FILES"
.AllowMultiSelect = False
.InitialFileName = strPath
If .Show <> -1 Then GoTo NextCode
sItem = .SelectedItems(1)
End With
NextCode:
GetFolder = sItem
Set fldr = Nothing
End Function
回答(6 个)
Matt Tearle
2011-6-8
Given how simple your file contents are, I'd use dlmread:
M = dlmread('filename.txt', ' ', 2, 0)
The last two arguments tell it to skip 2 rows (and no columns).
4 个评论
Matt Tearle
2011-6-10
Sorry, can't reproduce the problem. Perhaps some funky non-printing characters lurking in your file? One way to check for that is to do
foo = fileread('filename.txt');
then look at the values of double(foo). Values of 10 and/or 13 represent line breaks. Numbers should use characters 48-57 ('0'-'9') and 46 ('.') -- anything else would indicate a nonvalid number.
Is it always the last value? That is, what happens if you add a new value at the end of the file? Or insert a new value in the middle? That might help determine if it's the position or the specific value that happens to be at the end of your file.
Walter Roberson
2011-6-8
The exact method will depend on which reading routine you are using. textscan() offers a HeaderLines option; some of the other routines offer similar options.
2 个评论
Walter Roberson
2011-6-8
编辑:per isakson
2017-1-26
fid = fopen('DQ20091222000002.txt','rt');
indata = textscan(fid, '%f', 'HeaderLines',2);
fclose(fid);
yourdata = indata{1};
Sean de Wolski
2011-6-8
X = dlmread('ans68.txt','',2); %ans68.txt is your file.
doc dlmread
for more info
0 个评论
Abhishek Shahi
2018-7-1
编辑:Walter Roberson
2018-7-2
temp=importdata('abc.dat');
abc=temp.data;
clear temp;
Parvez Akhtar
2019-5-10
编辑:Parvez Akhtar
2019-5-10
Can anyone please help me out to skip lines from the end of the matrix data files as shown in below lines.
1. 23 45
2. 65 56
3. 64 87
4. 67 47
5. some additional comments at the end of the matrix.
In this data, we know the exact number of the last line, but for the bigger one, it is not easy to identify it. How can omit it while we are running the next read command?
0 个评论
Image Analyst
2023-2-4
allLines = readlines('ab.txt') % Gets every line into a cell.
% Skip first two lines
allLines = allLines(3:end) % Take only lines 3 and downward.
0 个评论
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Standard File Formats 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!