How to skip the first line of a text file when reading it?
327 ビュー (過去 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;
1 件のコメント
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!