string search and insert

Printable View

Nov 22nd, 2005, 01:35 AM
imatrox05

string search and insert

I have various HTML documents and particular items have been tagged like this

2

in the above tag the value between the font tag is 2. sometimes the value will be like this

2 3 4

where 3 and 4 denotes some specification .

and they have been wrongly tagged like this

2 3 4

whereas it should have been tagged like this

2 
3
4

Now i have many html docs like this and frankly its has given me a splitting headache...doing it manually.

How can i find these tags and replace them

Note Size=2 this number could vary for every tag
"CustomFont 1" is the font that's being used.

Thanks in advance
Nov 22nd, 2005, 06:14 AM
Ecniv

Re: string search and insert

Read up on the following functions :

open
print
line input (or was it 'input line'?)
replace
instr
close

You should be able to code a loop to replace the fonts as required (if they are htmlm files).

Or you can open in word and use its replace function. Similar code, but uh well word may sorta do things to the html code whilst it saves it.

Your choice
Nov 22nd, 2005, 10:23 AM
Webtest

Re: string search and insert

You're going to have to find the tag (hopefully the same tag for all) that encapsulates the string:
2 3 4
You will have to parse out the string then to find any hanging text after the tag.

Can you provide a little more of the HTML ... what tag encapsulates the string you provided?
Nov 25th, 2005, 01:08 AM
imatrox05

Re: string search and insert

Hi,

Webtest: The html goes like this

<DIV CLASS=T1>
(206 2 190)/190 5 8 percent.
</DIV>

Now in the line
5

here i have one value "5"
sometimes i might get 3 values

eg: 5 2 3

Such occurances must be replacd like this.

5
2
3

I am new to VBA and i have just written some basic code till date. and since time is a constraint, this would really help me out,

Thanks in advance