4 replies to this topic

[Chris Mackenzie]

Hi,

Dumping Pro-Isam data to sequential :
it mostly works but some of my datafiles do not
dump well. Instead of space padding in the fixed
length format sequential file fields, I get dodgy control
characters pushing the fields all over the place. As
far as I can see this non-printing data causes no problems
within Pro-IV and is invisible. I can re-enter data
in P4 and fix a record but don't want to do that with
everything. I tried the utility called 'PROTRACK' but
it does not pick up this corruption/invalid data.

Does anyone have any tools that might help?

I guess I will have to write some sort of cleanup
global logic to use where I check every char is
printable before writing to my seq file?

[Dan Shannon]

If anyone there knows Perl it would be easy enough to strip the dodgy characters and replace them with 0x20 (spaces) in the .seq files themselves.

Dan Shannon

[Chris Mackenzie]

Yeah,

But how to get the right number of spaces in?

Anyway - turns out there was a bug in my function
to delete FILEHDR & FILEDEF and it messed up the
data extraction function field assignments.

Fixed now and I am a happy man. Data conversion
one week ahead of schedule.

[Bryan Thompson]

You can try reading through the data and stripping out characters based on octal values. Also these characters may be invisible if your running green screen but should show up with the GUI client


Bryan

[Rajesh Chavan]

There is no utility in P4 to clean this junk records. To do this you have to copy the logical structure of the file. Then write a update to copy all the records using range. The range should be set before the junk records and follow the same step till you reach the EOF.