AnsweredAssumed Answered

Make Calculated Fields Ignore Text (make calculation ignore a string)

Question asked by bokenrosie on Feb 27, 2014
Latest reply on Feb 27, 2014 by philmodjunk

Title

Make Calculated Fields Ignore Text (make calculation ignore a string)

Post

     I have some html-code that I need to merge with fields in my database.  The code stays the same.  I have tried putting the string that follows in a calculated field and I get errors because the calculation is trying to work on what it finds inside quotes"

     Table Data =  Shrewsbury Borough School District

     HTML Data =  </font></b></font><font style="color: rgb(51, 51, 51); font-family: tahoma, geneva, sans-serif; font-size: 14px;"><br><br></font><font style="font-family: tahoma, geneva, sans-serif;"><b><font style="color: rgb(0, 90, 149); font-size: 16px;">$

     Desired Calculation is to have these two and a few others joined together into one field.

     I'm asking this question a different way than one I asked last night and received no replied.  Same problem, different way of looking at it.

     Thanks again.

Outcomes