I am using this formula
To parse data similar to the following.
<nobr> contractor information</nobr><br> <a href="../City_Electrical_Inspectors.htm"><b> City Electrical Inspectors</b></a><br> <nobr> <a href="../City_Electrical_Inspectors.htm"><b>inspection</b></a></nobr><br>
My problem comes in cases such as the first line, in which the line is not a new paragraph nor a link, and my
FIND returns an error of
Id like to create an
IF test to scan the line for the existence of the pattern in my
FIND statement before processing that statement. I figured that looking for an error condition may be the way to go. However, the only way I can envision this is as a self-referential formula, similart to the following pseudocode.
Can this be done with a formula or do I need to use a new helper column?