How to skip the first line of a text file when reading it?
323 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
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 comentario
Harsimran Singh
el 3 de Mayo de 2021
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
Respuestas (6)
Matt Tearle
el 8 de Jun. de 2011
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 comentarios
Matt Tearle
el 10 de Jun. de 2011
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
el 8 de Jun. de 2011
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 comentarios
Walter Roberson
el 8 de Jun. de 2011
Editada: per isakson
el 26 de En. de 2017
fid = fopen('DQ20091222000002.txt','rt');
indata = textscan(fid, '%f', 'HeaderLines',2);
fclose(fid);
yourdata = indata{1};
Sean de Wolski
el 8 de Jun. de 2011
X = dlmread('ans68.txt','',2); %ans68.txt is your file.
doc dlmread
for more info
0 comentarios
Abhishek Shahi
el 1 de Jul. de 2018
Editada: Walter Roberson
el 2 de Jul. de 2018
temp=importdata('abc.dat');
abc=temp.data;
clear temp;
1 comentario
Parvez Akhtar
el 10 de Mayo de 2019
Editada: Parvez Akhtar
el 10 de Mayo de 2019
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 comentarios
Image Analyst
el 4 de Feb. de 2023
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 comentarios
Ver también
Categorías
Más información sobre Standard File Formats en Help Center y File Exchange.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!