Visual Basic Forum for Visual Basic Programmers VB

[jws1]

Hi,

I am currently having trouble reading a text file into an array and then pasting each array (i.e. each line of the text file) into an excel spread sheet. The whole thing is numerical, however some of the numbers when read out of a program have , (e.g. £3,456,043.00) and when reading these particular lines into excel and putting them into cells the "," make the program think its a new line. I would either like to bypass the way it thinks "," are line breaks or run a find/replace routine on either the whole text file or on each line before addressing it to an array.

Any more info, please ask.

Regards,

John.

[RoofRabbit]

If I understand, you are reading a file with comma delimited values which could also be large values with commas within themselves? Is this an accurate description?
_________________
Website - [link]

[jws1]

Hi,

Basically it is all account balances, however on copying some of the values from the screen the input box has taken the "," as shown (£3,455,000.00) and when the text file is read into the array the "," mean array values 0,1,2 are taken up by the previous value, when infact I want the whole 3,455,000.00 read into array space 0 (or what ever array space it is upto). So either searching and replacing all "," in the text file with "" or make the VB code ignore "," is what I am after.

hope this clears things up a little.

Chers,

John