Vbscript write array to csv file

CreateObject "Scripting. OpenTextFile "Somefile. ReadLine,"," ' arrStr is now an array that has each of your fields ' process them, whatever Loop objTextFile. Please can you advise what I need to do to correct this?

Also, please can you advise how I get each field from the array as a variable by that I mean for example, how do I get the Username from the text file and assign it to be strUser so I can use it in the script? Thanks in advance. FileSystemObject" Simply thisyou're not running on a web server. Hope This Helps, PH. Stack Overflow for Teams — Collaborate and share knowledge with a private group. Create a free Team What is Teams? Collectives on Stack Overflow.

Learn more. Asked 7 years, 9 months ago. Active 7 years, 9 months ago. Viewed 2k times. Improve this question. Tom Stevens Tom Stevens 1 1 gold badge 1 1 silver badge 11 11 bronze badges. Add a comment. The values are assigned to the array by specifying array index value against each one of the values to be assigned. It can be a string. When the above code is saved as. Arrays are not just limited to single dimension and can have a maximum of 60 dimensions. Two-dimension arrays are the most commonly used ones.

ReDim Statement is used to declare dynamic-array variables and allocate or reallocate storage space. In the below example, an array has been redefined and then preserved the values when the existing size of the array is changed. There are various inbuilt functions within VBScript which help the developers to handle arrays effectively.

Advertiser Disclosure. Advanced Search. Results 1 to 4 of 4. Mel Guest. I am using the VBScript Split function to put the values into an array. At first everything seemed to work, but then I noticed one of the fields an address field contains commas on a few of the records.

In other words it is not confused by the additional commas.