Hi,
i am providing macro and test input file. Note, please change ext of input file from .txt to .sat.
If you run the macro and stop it just after reading in the file then yo uwill see that the last entry in array A(16) is a space .........why? and how to prevfent this?
It is not space - it is null string (""). Your file ends with vbNewLine and because you split on this character(s) the array has an empty element at the end. Why does this make a difference?
- Please remember to mark threads Solved with Thread Tools link at top of page.
- Please use code tags when posting code: [code]Place your code here[/code]
- Please read Forum Rules
You split using vbnewLine. So it returns an empty element an the end of your array.
It splits just after 10.46
You can Redim your array if you don't want the last element
Please Login or Register to view this content.
GC Excel
If this post helps, then click the star icon (*) in the bottom left-hand corner of my post to Add reputation.
ok.....so if i use vbnewline the last element in my array of lines from file will always be a nullstring?
if not then i what i prefer to do is have the last element in the array be the last actual line of data.
The data in your file ends with a new line - if you go to end of the file you are on blank line, not the last line of data. If you do not wish this, your following code may test for "" as array element or you may ignore this line at the start:
Please Login or Register to view this content.
did my last post make sense? typed it kinda fast.
If i simply remove/ignore the last element in the array (which i can do) will there ever be a time where removing/ignoring this last element causes me to remove/ignore actual data? if so then wouldnt it be better to some how read in file so that the last element in the array is the last actual row of data.........
of course how to do this i dont know
thanks Izandol
i was hoping you could explain these lines of code a little more
i think the first line assigns the entire text-file to the string variable stFile.Please Login or Register to view this content.
But i dont get the next two lines..........
That is correct. The first line reads in the whole file. The second line tests if it ends with vbNewLine and removes that if it does so you will not have an empty element when you Split.
Note that vbNewLine is actually two characters - a carriage return (vbCr) and then Line feed (vbLf) so we must test last two characters and not one.
thats exactly what i needed to know to understand it thanks.
i did not realize the vbnewline was two characters......
thanks again.
oh, one question i did have is this:
Reading in the entire file into a single string variable.................is there a limit to the size of the input file that can be assigned to the singl-string variable..........i guess does string variable have a num-char limit?
String variable limit is near 2 billion characters. If you have so much data I think you should use a different method!
wow! good to know..........2billion............wow!
thanks for the info
You may also like to consider ADO to read the text file data into a Recordset. It depends very much what you do with this data and how many records there may really be.
hi,
never used ado......or at least i dont think i have.........something new to learn. any good info on this ado?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks