Replace HTML String

[bigevilfish]

Hello All

 

First time posting, long time lurking and learning.

I need to replace some html in multiple files one after the other with some information from an excel spreadsheet

 

for example the HTML file contains this string

Reference:</td><td style="padding: 0px 10px 0px 10px;margin: 2px;font-size: 8pt;">

 

i want to add a value to the end like so

 

Reference:</td><td style="padding: 0px 10px 0px 10px;margin: 2px;font-size: 8pt;">$VISION_ID

but as the string contains " I'm not sure how to work around it

I know the answer will be simple but i just can't figure this one out

 

this is how far i got until i had trouble with the "

 

Sleep (1000)
Local $FromTo = $oWorkbook2.Worksheets(1).Range("B1").Value       
Sleep (1000)
Local $sFind = "Reference:</td><td style="padding: 0px 10px 0px 10px;margin: 2px;font-size: 8pt;">"
Local $sReplace = $FromTo
Local $sFilename = "C:\extract\Daily_import.html"
Local $iRetval = _ReplaceStringInFile($sFilename, $sFind, $sReplace)
Sleep (1000)

 

 

 

Thanks in advance

 

 

[Jfish]

Try surrounding your string with single quotes

'Reference:</td><td style="padding: 0px 10px 0px 10px;margin: 2px;font-size: 8pt;">'

That way everything within the single quotes is treated as the string.

[bigevilfish]

omg!! so simple!

 

 thank you (i was working my way through """ /"" /"/ and so on)