Hi. I’m having problems with text files
Specifically I want to get the rows starting from the 9th column in files
The remaining lines, if not starting from the 9th column, will delete the entire row
I have tried with generate datatable then filter data table but it doesn’t work for me.
So I would really appreciate it if someone could show me how to do it
doc.txt (130 Bytes)
Input
Output
Hello @Akaza
How you are getting this files? Is this format the same for the input file or will it get change?
1 Like
arrLinesFiltered = File.ReadAllLines(YourFilePath).Where(Function (x) x.TakeWhile(Function (s) s.equals(" "c)).count > 6).ToArray
strText = String.Join(Environment.NewLine, arrLinesFiltered)
arrLinesFiltered | DataType: String() - String Array
strText | DataType: String
YourFilePath - Your FullFilePath to the text file
2 Likes
it is an output of a macro. After changing, the format will not change
thanks i will try and reply you later
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.