How can we programmatically scan & update the blob field in the F00165 Media Objects table?

MrChuckles

Member
How can we programmatically scan & update the blob field in the F00165 Media Objects table?

Would like to know the perferred method of reading & editing a blob field (like in the F00165 Media Object table). It seems we have a lot of extra <CR> (Carriage Returns) and <LF> (Line Feeds) in the blob data (after a conversion from Sequel SQL to Oracle SQL) that we would like to scan for and remove. Otherwise, we are getting a lot of empty lines on some of the reports where we display the Media Object text. Can this be performed with standard BF's in ER scripting? Or does anyone have a sample program?
 
Top