11 Replies Latest reply: Jan 24, 2013 11:11 AM by JULIAN Rodriguez RSS

    Load a single field with NO TRIM of spaces around record

    Jose Adriano Baltieri

      Hello !

      Have a plain AscII file, variable length records , that I want to load as A SINGLE FIELD (a string with say 80 characters).

       

      Here's a sample of the data :

       

      [CODE]

      SBL01 16/04/2010 15:54:14 TC00101
      SBL01 16/04/2010 15:54:44 TC00101
      SBL01 16/04/2010 15:55:14 TC00101
      16/04/2010 07:29:10 TC00101
      16/04/2010 07:30:14 TC00101
      16/04/2010 07:30:43 TC00101
      16/04/2010 07:31:12 TC00101
      16/04/2010 07:31:41 TC00101
      16/04/2010 07:32:10 TC00101
      CDES1 16/04/2010 08:49:49 TC06699 086330 1
      CDES1 16/04/2010 08:49:49 TC06701
      CDES1 08:49:49 TC00901
      CDES1 16/04/2010 08:50:00 TC00202
      CDES1 16/04/2010 08:50:01 TC06501
      CDES1 16/04/2010 08:50:01 TC06701
      CDES1 16/04/2010 08:50:01 TC00901
      CDES1 16/04/2010 08:50:04 TC06606
      CDES1 16/04/2010 08:50:05 TC06699 086330 1
      CDES1 16/04/2010 08:50:05 TC06701
      CDES1 16/04/2010 08:50:05 TC00901
      CDES1 16/04/2010 08:54:10 TC00101
      CDES1 16/04/2010 08:54:38 TC00101
      CDES1 16/04/2010 08:54:42 TC06606
      CDES1 16/04/2010 08:54:43 TC06699 086330 1
      CDES1 16/04/2010 08:54:43 TC06701
      CDES1 16/04/2010 08:54:43 TC00901
      CBITE 01/04/2010 12:08:10 TC06699 324068 3
      CBITE 01/04/2010 12:08:10 TC06701
      CBITE 01/04/2010 12:08:10 TC25901
      CBITE 01/04/2010 12:08:20 TC26301
      CBITE 01/04/2010 12:12:00 TC00101
      CBITE 01/04/2010 12:12:18 TC00101
      CBITE 01/04/2010 12:12:47
      CBITE 01/04/2010 12:13:15 TC00101
      CBITE 01/04/2010 12:13:45 TC00101
      CBITE 01/04/2010 12:14:14 TC00101
      CBITE 01/04/2010 12:14:50 TC00101
      CBITE 01/04/2010 12:15:19 TC00101
      CBITE 01/04/2010 12:15:48 TC00101
      CBITE 01/04/2010 TC00101
      CBITE 01/04/2010 12:16:47 TC00101
      CBITE 01/04/2010 12:17:16 TC00101
      CBITE 01/04/2010 12:17:45 TC00101
      CBITE 01/04/2010 12:18:14 TC00101
      CBITE 01/04/2010 12:18:43 TC00101
      CBITE 01/04/2010 12:19:12 TC00101
      CBITE 01/04/2010 12:19:41 TC00101
      CBITE 01/04/2010 12:20:10 TC00101
      CBITE 01/04/2010 12:20:39 TC00101
      CBITE 01/04/2010 12:21:08 TC00101
      CBITE 01/04/2010 12:21:37 TC00101

      [/CODE]

      I need to load this data as A SINGLE FIELD, without trimming spaces around the record.

       

      Say record # 4, it should be loaded as " 16/04/2010 07:29:10 TC00101" , that is, with spaces on the left side as on the original record.

       

      How do I do that ?

       

      Thanks !

       

      By the way, have provided a simple kit file for testing purposes...