vbscript required for data transform task in SQL
Posted on 2004-10-20
I need some VBScript for a data transform task in a DTS package.
the data I have looks like the following:
71. Progress status of software installation 72. Print cartridges installation 73. Loading standard size paper 74. Changing print settings (eg. type of paper, size) 75. Inserting memory card (if applicable) 76. Setting up the fax function (if applicable) 77. Using scanner function 78. Clarity on control panel operation 79. Other (... Please Specify Q15C5)
I need to parse it and get the number in a variable, and I need the text behind it in a variable.