some tricky text manipulation

[sumit]

Hi Guys can you write a script or suggest how to write a script which will read a text file containing the following two lines

Browser("the HiringTool - Employer").Page("the HiringTool - Post").WebList("Industry").Select "Securities"

Browser("the HiringTool - Employer").Page("the HiringTool - Post").WebList("JobCategory").Webedit "Taxes"

and output two files

1 excel file with the following lines

2 text file containing following lines

Browser(x1).Page(x2).WebList(x3).Select x4

Browser(x1).Page(x2).WebList(x3).Webedit x4

Help will be much appreciated

[dbzfanatic]

There are built in excel functions, search the helpfile for them. Also search for StringSplit(), FileRead(), and FileWrite().

[sumit]

There are built in excel functions, search the helpfile for them. Also search for StringSplit(), FileRead(), and FileWrite().

can anybody give the code

[dbzfanatic]

If you want someone to do the code for you go to rentacoder.com You said you wanted to be pointed in the right direction, so that's what I did. Then again you could always just do it by hand or the better solution which is to...

Read the helpfile and examples and learn to do it yourself *dramatic music*, trust me it pays off in the long run.

Edited September 23, 2008 by dbzfanatic