I have a string that resides in a table called itemresponse, and the field name is youranswer. In the youranswer field I have a string that looks like
response~A^correct~1^confirmed~0 or response~B^Correct~0 Is there a way to use Cold Fusion to update youranswer field and get rid of everything after Correct~0 so that the strings that are response~B^correct~0^confirmed~1 turn into response~A^correct~1? The are about 500K answers in this field and like I said, some are already the shorter version while most of them are the long string.
Any help would be appreciated