Webmaster Forum / ColdFusion / Advanced Techniques / October 2004

Hi,  I have a stored procedure that I am calling from our database and
displaying the results on our webpage.  The data within the results needs to be
parsed.  For example, it now comes back as Primary Demand: bla bla bla Primary
Output: blah blah blah Secondary Output : blah blah blah Tertiary Output: bla
bla bla, etc.  I need Primary Output, Secondary Output , and Tertiary Output to
show up on separate lines ( I know I know...not very good database
normalization, but it's legacy stuff I'm dealing w/).  like this --->
Primary Demand: bla bla bla Primary Output: blah blah blah  Secondary Output :
blah blah blah  Tertiary Output: bla bla bla, etc.  I have this in there right
now: #Replace(Content.Measures,"Primary
Output","<br>Primary Output")# which takes care of
separating Primary Demand & Primary Output...how do I go further.  Can I
concatenate things I want to replace?!?!  I don't know if this makes sense or
not, so if anyone can help or lead me in the right direction, please let me
know.  THANKS!!!