VBSCript to parse text file
Posted on 2006-03-29
I'm an old school C programmer and would like to make the switch to VBScript. I know how to do this in C but i really would like to do this using VBscript. I have a text file with the following contents:
8403 SE May Valley Rd Issaquah WA 98027
The info in the lines vary but once i have the basic script i can modify it to suite my needs. I want open a text file, read it, parse it and then write the results to another txt file. I would like to seperate out the individual address fields. (i.e. Street address, city, state, zip). I want to reformat the line with commas separating the fields and write this to another file. In C i would parse these lines in reverse (using the space as a delimiter). On some of the lines there is an account #at the end of the lines. the account # is prepended by the string: "Acct #".
Any help would be most appreciated. I don't have the luxury of time to learn VBScript from scratch.