How to write a matrix or array to a text file?

[deeptismuley]

Hello,

i want to write an array to a text file using visual basic. the output should look like this for a 5X5 sized array.

0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 1 0
0 0 0 0 0

All the elements will be zero except one. When i am trying to write using Print#1 statement then i am getting one element on one line. How to do this???

thank you in advance

[Killer42]

Does it actually matter what the data looks like in the file, or do you just need to be able to read it back into the array?

[deeptismuley]

Does it actually matter what the data looks like in the file, or do you just need to be able to read it back into the array?

hello,

the data should look like as typed by me, as it will be read as array (a matrix of 5 X 5) afterwords. so its necessary to have spaces in between & 5 items in a row.
The matrix size will change according to the requirements, so its not possible to use a statement like- Print #1 0 0 0 0 0.

Thank you for your response.

[Killer42]

The point I was trying to make is that you can store an array straight to file in one statement, and retrieve it again later.

Otherwise, I'd say what you need to know is that you can end the Print statement with a semicolon (;) to leave out the line break. For example:

Print #1, MyArray(1);

This will not insert a line break, so the next thing you write/print to the file will continue on the same line.

[hariharanmca]

hello,

the data should look like as typed by me, as it will be read as array (a matrix of 5 X 5) afterwords. so its necessary to have spaces in between & 5 items in a row.
The matrix size will change according to the requirements, so its not possible to use a statement like- Print #1 0 0 0 0 0.

Thank you for your response.

Just try like this.....

Option Explicit
Dim xyz(5, 5) As String
Dim tmpStrValue As String
Dim i As Integer
Dim j As Integer
 
Private Sub PrintMatrixForum()
    For i = 1 To 5
        For j = 1 To 5
            xyz(i, j) = i + j
        Next j
    Next i
    tmpStrValue = ""
    For i = 1 To 5
        For j = 1 To 5
            tmpStrValue = tmpStrValue & xyz(i, j) & " "
        Next j
        tmpStrValue = tmpStrValue & vbCrLf
    Next i
    MsgBox tmpStrValue
    tmpStrValue = ""
End Sub

[deeptismuley]

The point I was trying to make is that you can store an array straight to file in one statement, and retrieve it again later.

Otherwise, I'd say what you need to know is that you can end the Print statement with a semicolon (;) to leave out the line break. For example:

Print #1, MyArray(1);

This will not insert a line break, so the next thing you write/print to the file will continue on the same line.

hi,

I dont have any array with me i have to create it, may be using for loop with i & j. I will try out putting semicolon at the end of statement to see whether it works or not.

thank you

[hariharanmca]

hi,

I dont have any array with me i have to create it, may be using for loop with i & j. I will try out putting semicolon at the end of statement to see whether it works or not.

thank you

is it you front-end VB, then why to have semicolon at the end?

[deeptismuley]

The point I was trying to make is that you can store an array straight to file in one statement, and retrieve it again later.

Otherwise, I'd say what you need to know is that you can end the Print statement with a semicolon (;) to leave out the line break. For example:

Print #1, MyArray(1);

This will not insert a line break, so the next thing you write/print to the file will continue on the same line.

Its working now,

thanks a lot Killer

[deeptismuley]

is it you front-end VB, then why to have semicolon at the end?

great!!!!!!!!!

I have solved the problem with help of you and killer.

thanks to both of you.

Regards

[Killer42]

is it you front-end VB, then why to have semicolon at the end?

That was my suggestion - a semicolon on the end of the Print # statement to skip the line break, so the next element is written on the same line. Very much like your code, except that I assumed that deeptismuley wanted to write the elements individually to the file, while you are accumulating them into a string, which can then be written.

Just a slightly different approach, is all.

[hariharanmca]

That was my suggestion - a semicolon on the end of the Print # statement to skip the line break, so the next element is written on the same line. Very much like your code, except that I assumed that deeptismuley wanted to write the elements individually to the file, while you are accumulating them into a string, which can then be written.

Just a slightly different approach, is all.

For that we have to use ' : '
But i never tried ' ; '

[Killer42]

For that we have to use ' : '
But i never tried ' ; '

Perhaps there are differences in versions of VB from around the world. But in my version, the colon (:) is used to delimit multiple statements on a line, and the semicolon (;) is used between elements in a Print statement to concatenated them.

Examples...

A = 1 : B = 2 '       <-- Colon between statements
Debug.Print A; B '    <-- Semicolon between printed elements.