Insert carriage return or line feed 1

[daybase]

I have a query that extracts data from text based memo fields (created by somebody else) originally designed to create html pages. My query strips out the html code using:

stripfile = replace(stripfile, "</font>", "")

I now want to take this further by introducing formatting depending on the text content - for example wherever the word "Location" appears I would like to insert a carriage return or line feed. I have tried

stripfile = replace(stripfile, "Location:", Chr(13) & " Location:")

But without success - all a bit of a mystery to me - any suggestions?

 

[PHV]

Perhaps this ?
stripfile = Replace(stripfile, "Location:", vbCrLf & " Location:")

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[daybase]

yep - works a treat. Many thanks