how to split a string

[963852741159753]

Create a string slicing programme that will take data from a spreadsheet (as given) and output to a ‘delimited ASCII file’

[hariharanmca]

Create a string slicing programme that will take data from a spreadsheet (as given) and output to a ‘delimited ASCII file’

use split(stringVal ue,delimitedStr ing) return string array

[963852741159753]

sorry what is the code for that i am an amature

[hydro]

hi yeah what ks the code please it would be a great help
thanx

[hariharanmca]

sorry what is the code for that i am an amature

are you asking in Vb for split

[963852741159753]

yes please

[hariharanmca]

yes please

Private Sub splitStrintValu e()
Dim strVal As String
Dim charVal(11) As String
strVal = "A,B,C,D,E,F,G, H,I,J,K"
charVal = Split(strVal, ",")
strVal = Join(charVal, "-")
'Out Put of strVal = A-B-C-D-E-F-G-H-I-J-K
End Sub

[963852741159753]

thanks but what i need is to read a txt file into an array string slice it and to write it back a delimted ascii file if can help much appreciated

[hariharanmca]

thanks but what i need is to read a txt file into an array string slice it and to write it back a delimted ascii file if can help much appreciated

sorry, i am not getting 'delimited ASCII file’.........?

[963852741159753]

sorry. M.Molloy@2005.l jmu.ac.uk*MR.MA LACHI MOLLOY*<>*<2665 65>*<2111108950 9137> the stars are the delimeters. what i need to do is seperate them into seperate colums and then import them into an access database any ideas. thanks m8

[hariharanmca]

sorry. M.Molloy@2005.l jmu.ac.uk*MR.MA LACHI MOLLOY*<>*<2665 65>*<2111108950 9137> the stars are the delimeters. what i need to do is seperate them into seperate colums and then import them into an access database any ideas. thanks m8

i think some post are there to read from file and get the file input string then use split(inputstri ng,"*") into an array then you can store in database

[963852741159753]

do you have a code example please

[hariharanmca]

sorry. M.Molloy@2005.l jmu.ac.uk*MR.MA LACHI MOLLOY*<>*<2665 65>*<2111108950 9137> the stars are the delimeters. what i need to do is seperate them into seperate colums and then import them into an access database any ideas. thanks m8

...Removed by Moderator

TheScripts has policies against providing students with answers to their assignments.

We are here to help, not to do the work for you.

i think this will help you

[963852741159753]

thanks but i am using vb.2005 and some of the things do work any more ideas thanks

[Jewkes]

I was wondering how to import data from a text file in order to split it using vb 2005