vbs read text file line by line and split it with commaVBScript variable loses its content?SFTP transfer file and move file to folderBatch file running two vbs scripts for backing upReading File Line By LineVBS slows near the endreading a text file line by line and putting the lines into lists in JavaVBScript Error 9 in AtEndOfStream LoopHow does VBScript store the vbCrLF character within a parsed array of strings?Bulk email using VBSTrying to compare the 2 most recent files in a folder and process if different
A horrible Stockfish chess engine evaluation
DFT vs. MP2 for stacked dimer
Why didn't Thanos kill all the Dwarves on Nidavellir?
Misspelling my name on my mathematical publications
Which type of trumpet is typically used to perform Bach Brandenburg 2
How to deal with moral/legal subjects in writing?
How can I get a player to accept that they should stop trying to pull stunts without thinking them through first?
What is this little owl-like bird?
Which star / galaxy is moving away from us the fastest?
What happened to people in unsafe areas during the Blip?
Is there any word for "disobedience to God"?
Salt, pepper, herbs and spices
Shortest hex dumping program
Were initial voiced stops voiceless in early Latin?
LED glows slightly during soldering
What's it called when the bad guy gets eaten?
Should disabled buttons give feedback when clicked?
How do we handle pauses in a dialogue?
If your plane is out-of-control, why does military training instruct releasing the joystick to neutralize controls?
Would it be appropriate to sand a floor between coats of poly with a handheld orbital sander?
What is the right approach to quit a job during probation period for a competing offer?
Is it OK to leave real names & info visible in business card portfolio?
Is "De qui parles-tu" (for example) as formal as it is in English, or is it normal for the French to casually say that
Diagonal arrows (using TikZ) should be aligned in parallel
vbs read text file line by line and split it with comma
VBScript variable loses its content?SFTP transfer file and move file to folderBatch file running two vbs scripts for backing upReading File Line By LineVBS slows near the endreading a text file line by line and putting the lines into lists in JavaVBScript Error 9 in AtEndOfStream LoopHow does VBScript store the vbCrLF character within a parsed array of strings?Bulk email using VBSTrying to compare the 2 most recent files in a folder and process if different
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;
has a text file with this contain
name1,21
name2,33
name4,22
how do i read and store this in other variable for example
name= name1
age= 21
print out this and loop until end of this file
print out will be
name: name1 is 21 years old
this is what i have tried but the message box i get are blank
Const ForReading = 1
Set objFSO = CreateObject("Scripting.FileSystemObject")
Set objTextFile = objFSO.OpenTextFile("C:my.txt", ForReading)
strOutput = ""
Do Until objTextFile.AtEndOfStream
strNextLine = objTextFile.Readline
arrServiceList = Split(strNextLine , ";")
If (UBound(arrServiceList) >= 6) Then
strOutput = strOutput & "name: " & arrServiceList(0) & ", age: " & arrServiceList(6) & vbCrLf
End If
Loop
WScript.Echo strOutput
all I'm getting is a blank box
vbscript line-by-line
asked Mar 26 at 0:55
Ajwad IbrahimAjwad Ibrahim
341 silver badge5 bronze badges
add a comment |
has a text file with this contain
name1,21
name2,33
name4,22
how do i read and store this in other variable for example
name= name1
age= 21
print out this and loop until end of this file
print out will be
name: name1 is 21 years old
this is what i have tried but the message box i get are blank
Const ForReading = 1
Set objFSO = CreateObject("Scripting.FileSystemObject")
Set objTextFile = objFSO.OpenTextFile("C:my.txt", ForReading)
strOutput = ""
Do Until objTextFile.AtEndOfStream
strNextLine = objTextFile.Readline
arrServiceList = Split(strNextLine , ";")
If (UBound(arrServiceList) >= 6) Then
strOutput = strOutput & "name: " & arrServiceList(0) & ", age: " & arrServiceList(6) & vbCrLf
End If
Loop
WScript.Echo strOutput
all I'm getting is a blank box
vbscript line-by-line
asked Mar 26 at 0:55
Ajwad IbrahimAjwad Ibrahim
341 silver badge5 bronze badges
You are splitting on;but your text has,.
– Noodles
Mar 26 at 1:20
Once you have resolved thesplitissue mentioned above, your arrayarrServiceListwill only contain 2 elements (unless you've provided a cut down version of the file and there are more data elements on each line), so referencingarrServiceList(6)will cause an array failure.
– Dave
Mar 26 at 1:35
add a comment |
has a text file with this contain
name1,21
name2,33
name4,22
how do i read and store this in other variable for example
name= name1
age= 21
print out this and loop until end of this file
print out will be
name: name1 is 21 years old
this is what i have tried but the message box i get are blank
Const ForReading = 1
Set objFSO = CreateObject("Scripting.FileSystemObject")
Set objTextFile = objFSO.OpenTextFile("C:my.txt", ForReading)
strOutput = ""
Do Until objTextFile.AtEndOfStream
strNextLine = objTextFile.Readline
arrServiceList = Split(strNextLine , ";")
If (UBound(arrServiceList) >= 6) Then
strOutput = strOutput & "name: " & arrServiceList(0) & ", age: " & arrServiceList(6) & vbCrLf
End If
Loop
WScript.Echo strOutput
all I'm getting is a blank box
vbscript line-by-line
asked Mar 26 at 0:55
Ajwad IbrahimAjwad Ibrahim
341 silver badge5 bronze badges
has a text file with this contain
name1,21
name2,33
name4,22
how do i read and store this in other variable for example
name= name1
age= 21
print out this and loop until end of this file
print out will be
name: name1 is 21 years old
this is what i have tried but the message box i get are blank
Const ForReading = 1
Set objFSO = CreateObject("Scripting.FileSystemObject")
Set objTextFile = objFSO.OpenTextFile("C:my.txt", ForReading)
strOutput = ""
Do Until objTextFile.AtEndOfStream
strNextLine = objTextFile.Readline
arrServiceList = Split(strNextLine , ";")
If (UBound(arrServiceList) >= 6) Then
strOutput = strOutput & "name: " & arrServiceList(0) & ", age: " & arrServiceList(6) & vbCrLf
End If
Loop
WScript.Echo strOutput
all I'm getting is a blank box
vbscript line-by-line
vbscript line-by-line
asked Mar 26 at 0:55
Ajwad IbrahimAjwad Ibrahim
341 silver badge5 bronze badges
asked Mar 26 at 0:55
Ajwad IbrahimAjwad Ibrahim
341 silver badge5 bronze badges
asked Mar 26 at 0:55
Ajwad IbrahimAjwad Ibrahim
341 silver badge5 bronze badges
asked Mar 26 at 0:55
Ajwad IbrahimAjwad Ibrahim
341 silver badge5 bronze badges
asked Mar 26 at 0:55
Ajwad IbrahimAjwad Ibrahim
341 silver badge5 bronze badges
341 silver badge5 bronze badges
You are splitting on;but your text has,.
– Noodles
Mar 26 at 1:20
Once you have resolved thesplitissue mentioned above, your arrayarrServiceListwill only contain 2 elements (unless you've provided a cut down version of the file and there are more data elements on each line), so referencingarrServiceList(6)will cause an array failure.
– Dave
Mar 26 at 1:35
add a comment |
You are splitting on;but your text has,.
– Noodles
Mar 26 at 1:20
Once you have resolved thesplitissue mentioned above, your arrayarrServiceListwill only contain 2 elements (unless you've provided a cut down version of the file and there are more data elements on each line), so referencingarrServiceList(6)will cause an array failure.
– Dave
Mar 26 at 1:35
You are splitting on
; but your text has ,.– Noodles
Mar 26 at 1:20
You are splitting on
; but your text has ,.– Noodles
Mar 26 at 1:20
Once you have resolved the
split issue mentioned above, your array arrServiceList will only contain 2 elements (unless you've provided a cut down version of the file and there are more data elements on each line), so referencing arrServiceList(6) will cause an array failure.– Dave
Mar 26 at 1:35
Once you have resolved the
split issue mentioned above, your array arrServiceList will only contain 2 elements (unless you've provided a cut down version of the file and there are more data elements on each line), so referencing arrServiceList(6) will cause an array failure.– Dave
Mar 26 at 1:35
add a comment |
1 Answer
1
active
oldest
votes
finally managed to get it work, just sharing, below are my code:
Set fso=CreateObject("Scripting.FileSystemObject")
filename = "C:my.txt"
listFile = fso.OpenTextFile(filename).ReadAll
listLines = Split(listFile, vbCrLf)
i = 0
For Each line In listLines
Dim arr
arr = Split(line,",")
WScript.Echo CStr(i) + " Name: " + arr(1)+ " age: "+arr(0)
Next
not sure if this is the best solution, anyone got better ?
first i split it line by line, then from that line i split it by comma
answered Mar 26 at 3:20
Ajwad IbrahimAjwad Ibrahim
341 silver badge5 bronze badges
add a comment |
Your Answer
StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55348401%2fvbs-read-text-file-line-by-line-and-split-it-with-comma%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
finally managed to get it work, just sharing, below are my code:
Set fso=CreateObject("Scripting.FileSystemObject")
filename = "C:my.txt"
listFile = fso.OpenTextFile(filename).ReadAll
listLines = Split(listFile, vbCrLf)
i = 0
For Each line In listLines
Dim arr
arr = Split(line,",")
WScript.Echo CStr(i) + " Name: " + arr(1)+ " age: "+arr(0)
Next
not sure if this is the best solution, anyone got better ?
first i split it line by line, then from that line i split it by comma
answered Mar 26 at 3:20
Ajwad IbrahimAjwad Ibrahim
341 silver badge5 bronze badges
add a comment |
finally managed to get it work, just sharing, below are my code:
Set fso=CreateObject("Scripting.FileSystemObject")
filename = "C:my.txt"
listFile = fso.OpenTextFile(filename).ReadAll
listLines = Split(listFile, vbCrLf)
i = 0
For Each line In listLines
Dim arr
arr = Split(line,",")
WScript.Echo CStr(i) + " Name: " + arr(1)+ " age: "+arr(0)
Next
not sure if this is the best solution, anyone got better ?
first i split it line by line, then from that line i split it by comma
answered Mar 26 at 3:20
Ajwad IbrahimAjwad Ibrahim
341 silver badge5 bronze badges
add a comment |
finally managed to get it work, just sharing, below are my code:
Set fso=CreateObject("Scripting.FileSystemObject")
filename = "C:my.txt"
listFile = fso.OpenTextFile(filename).ReadAll
listLines = Split(listFile, vbCrLf)
i = 0
For Each line In listLines
Dim arr
arr = Split(line,",")
WScript.Echo CStr(i) + " Name: " + arr(1)+ " age: "+arr(0)
Next
not sure if this is the best solution, anyone got better ?
first i split it line by line, then from that line i split it by comma
answered Mar 26 at 3:20
Ajwad IbrahimAjwad Ibrahim
341 silver badge5 bronze badges
finally managed to get it work, just sharing, below are my code:
Set fso=CreateObject("Scripting.FileSystemObject")
filename = "C:my.txt"
listFile = fso.OpenTextFile(filename).ReadAll
listLines = Split(listFile, vbCrLf)
i = 0
For Each line In listLines
Dim arr
arr = Split(line,",")
WScript.Echo CStr(i) + " Name: " + arr(1)+ " age: "+arr(0)
Next
not sure if this is the best solution, anyone got better ?
first i split it line by line, then from that line i split it by comma
answered Mar 26 at 3:20
Ajwad IbrahimAjwad Ibrahim
341 silver badge5 bronze badges
answered Mar 26 at 3:20
Ajwad IbrahimAjwad Ibrahim
341 silver badge5 bronze badges
answered Mar 26 at 3:20
Ajwad IbrahimAjwad Ibrahim
341 silver badge5 bronze badges
answered Mar 26 at 3:20
Ajwad IbrahimAjwad Ibrahim
341 silver badge5 bronze badges
341 silver badge5 bronze badges
add a comment |
add a comment |
Got a question that you can’t ask on public Stack Overflow? Learn more about sharing private information with Stack Overflow for Teams.
Got a question that you can’t ask on public Stack Overflow? Learn more about sharing private information with Stack Overflow for Teams.
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55348401%2fvbs-read-text-file-line-by-line-and-split-it-with-comma%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
You are splitting on
;but your text has,.– Noodles
Mar 26 at 1:20
Once you have resolved the
splitissue mentioned above, your arrayarrServiceListwill only contain 2 elements (unless you've provided a cut down version of the file and there are more data elements on each line), so referencingarrServiceList(6)will cause an array failure.– Dave
Mar 26 at 1:35