Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 84
  • Last Modified:

Write data from SQL to CSV file - position

I am trying to create a sub to write fixed lenght to cvs file. Could you help? Max lenght per line is 500.

    Public Sub ExportOrderData()
        Using MyFile1 As New StreamWriter("C:\Temp\MyFile.csv")
         
           position 10 - 15 = write Order #
           position 17 - 25 = write Description
           position 30 - 100 = write Address  

           max size per line is 150


        End Using
    End Sub
0
jagr12
Asked:
jagr12
1 Solution
 
Fernando SotoRetiredCommented:
Hi  jagr12;

You can use the String.Format Method which will allow you to give field a width value for each specific line position, spaces between columns, how to justify the data in the field and many other options, Have a look at the Microsoft documentation String.Format Method.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now