Project Comments in query output Formatting

Summary:

User created a comment on Project level (might have been copy pasted from some other source), when a sql is written to extract the information, it has all sorts of formatting string included. What do I need to include in the query to get rid of it please?

Content (please ensure you mask any confidential information):

This is what it looks like in the front end:

This is the query output:

Query at this stage is straight forward:

SELECT note_txt FROM zmm_notes WHERE source_object_uid = ppa.project_id AND note_type_code = 'PROJECT' AND visibility_code = 'INTERNAL'