i need help splitting a txt file username:passsword format

shailzrocks said:

Paste them in Excel

Select the Column. Look for this option "Text to Column"

Select delimited, then select others and write ":" (without qoutes)

Ok and Finish

Click to expand...

shailzrocks said:

Paste them in Excel

Select the Column. Look for this option "Text to Column"

Select delimited, then select others and write ":" (without qoutes)

Ok and Finish

Click to expand...

Herion said:

Quickly coded this in visual basic. Requires .NET Framework 4.0, splits using the delimiter ":", comes with the source if you want to make modifications or recompile.

Code:

        Dim array As String() = RichTextBox1.Lines
        Dim arraycount As Integer = array.Length
        Dim i As Integer = 0
        Do While i <> arraycount
            Dim arr As String() = array(i).Split(":")
            RichTextBox2.Text += arr(0) & vbCrLf
            RichTextBox3.Text += arr(1) & vbCrLf
            i += 1
        Loop

Click to expand...