DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2001
    Lafayette, La
    I have a fixed width file with the leading spaces for all the columns. I would like to trim all the data so all the columns come in left justified. Is it possible to use the trim command inside the control file?
    What would be an alternative method?

  2. #2
    Join Date
    Oct 2000
    In your control file, when defining the fields you can also put a peice of SQL on the field and you do it something like this

    field POSITION(1:9) CHAR(8) "rtrim(:field)"

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.