I am dealing with a large INP 'Fixed Width' file that after much faff I have now got down to approx. 160 errors.
These were mainly due to the original file containint non ASCII characters which were pushing rows 'out of sync'.
I have tried the UTF8 to ASCII converstion option which seemed to get rid of a load of problems, but there are 160 odd left.
An example of a problem row would be a row where the title starts at position 134 instead of 135. I have to locate the row out of sync and mouse click just before the Title and hit the space bar to move everything that follows in the row along one byte so the fixed width structure is correct.
This is a bit of a nightmare - esp as you get an hour glass of 10 seconds when you perform the next 'goto' search!
SO - I was wondering if there is macro or easy way to scan the whole file and if anything is not in it's correct column it will automatically position the start point for that field at the correct position.
I know there is the 'convert to fixed columns' option - but not sure if that will fix the 160 rows that are starting at the wrong position. Will it ignore any character left say in column 134 - thus leaving it there and corrupting the file?
I am not sure I am explaining this well - but if you could offer any advice - that would be great!
ps - I am using Ultra Edit32 v 9.10a
pps - the fixed width file structure I need to adhere to is: