Jump to content
Sign in to follow this  
sumit

some tricky text manipulation

Recommended Posts

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

Posted Image

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 :)

Share this post


Link to post
Share on other sites
dbzfanatic

Share this post


Link to post
Share on other sites
sumit

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

can anybody give the code

Share this post


Link to post
Share on other sites
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 by dbzfanatic

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.