3 Replies Latest reply on Feb 27, 2014 6:19 AM by philmodjunk

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

    bokenrosie

      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.