Ways to delimit your text in VBSCRIPT

Vote count:

0

I have a file with the following inputs

"SMEGOLD 1312",20131127,"C","11606233E","SMX","C",20131009,170028,"SMX","70207",0,1,4699,0,469.9,"USD",0,"",0,"",0,"",0,"",0,0,0,8062696,"",0,20131009,170028,"SYSTEM","25228","","166","121328200000223",785,0,"","","","","","","","","","","","",0,0,0,"",20131009,170028,"ADVMEE"

"SMEGOLD 1312",20131127,"C","11606233E","SMX","C",20131009,170030,"SMX","70207",0,1,4699,0,469.9,"USD",0,"",0,"",0,"",0,"",0,0,0,8062697,"",0,20131009,170031,"SYSTEM","25228","","167","121328200000223",786,0,"","","","","","","","","","","","",0,0,0,"",20131009,170028,"ADVMEE"

What i would like to achieve is to only obtain the first quote text of the line. Example "SMEGOLD 1312". Then i would like to append the first 3 characters and the last 4 characters of that extracted text to the back of line.

And move to the next line to carry on with the procedure till the end of the file.

Any advise will be a great help. I tried using the objRegEx.Pattern but to no avail

Thanks

asked 29 secs ago

user3783939

1