DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: fixed width file with control file -? trim

  1. #1
    Join Date
    Jul 2001
    Location
    Lafayette, La
    Posts
    3
    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
    Posts
    90
    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