You can write a program to go through the file and update the records.
Use %XLATE to covert the bad characters to blanks.
If you kinow the record number or some other key, you can have your program receive that as a parm and just do the update to the one record.
Check this out:
FIRE THE USER … OR BILL HIM / HER OR THEIR DEPARTMENT FOR THE
TIME TAKEN TO FIX THE RECORDS …
I’M KIDDING, OF COURSE, ABOUT THE FIRING …BUT THERE IS A REAL USER ISSUE HERE …
AND THE FACT THAT IT’S A BUSY FILE COULD CAUSE A SERIOUS PROBLEM …
ALSO SEE THE NEXT ANSWER …
BOTTOM LINE … ONE WAY OR ANOTHER THIS FAULTY DATA ENTRY HAS TO STOP …
If input is occurring in RPG you will want to use the XLATE on the incoming data.
The page referenced above gives the hex codes in and hex codes out to correct for cut and paste
values that don’t work on the 400. If you’re in cobol you will have to make something similar.
If the data is coming in directly from web applications then you will have to fix data fields after creation
or use a before trigger function to correct the incoming data.