home recent topics recent posts search faq
Home » Scripting » VB Script Help Messages in this topic - RSS
|
10/26/2011 10:40:44 AM
shakeel
shakeel
Posts 1 		Hi All,

I am new to VB script world.

I need some help on creating new VB script for the text file changes:

I am receiving below sample text file data and needs to modify and export to new text file.

OP01AMS06902APECS 20110905154741 2 T.M.FINAP033.00120110905034752 (header portion of the file needs to validated and removed while exporting to new file)
6301405159509 0000000700 20110504 110.00 USD 0000077191 US Auto Fo US Auto Fo 100000 ABC Fort Worth TX 76137
6301405159509 0009000015 20110726 200.00 USD 0000077897OL00000001Vamsi Vamsi vamsi house 123
CL99AMS06902APECS 20110905154741 2 T.M.FINAP033.00120110905034752 (trailer portion of the file needs to validated and removed while exporting to new file)

And while exporting to new file I need to append constant records data in each single row.

For instance for the first above record apart the existing data I need to append 58 constant record data for reach row.

000001 0000000 6301405159509 0000000700 20110504 110.00 USD 0000077191 US Auto Fo US Auto Fo 100000 ABC Fort Worth TX 76137

Any help or sample scripts will be greatly appreciated.

Thanks
Shakeel.
edited by shakeel on 10/26/2011
pages: 1
|
Home » Scripting » VB Script Help