I have a file generated from the mainframe which fills each line to 80 characters with spaces. The files can be around 100,000 lines which makes for a larger file than it should be. Each line of data is variable & can be from zero to 40 or 50 characters per line. Is there a way to have KiXtart remove these excess spaces. The file is read in by another app & is keeping the blank spaces in its database. I looked at RTRIM but couldn't quite master it.
thanks