5 Replies Latest reply: Jan 28, 2013 6:35 AM by Rahul_India RSS

    Help in writing SQL query

    982895
      Hi evrybody,

      I have a requirement which seems very wierd to me, I m unable to clue it also. Please help me in writing the same.
      I have a column in a table which contains the data with spaces and everythng same as below:
      SUBSCRIBER LINE TEST

      VERSION 2

      DEV SNB MP FCODE
      LIBA-13 4222430012 11 3

      FOREIGN VOLTAGE TESTS

      DC AC
      FVAE FVBE FVAB FVAE FVBE FVAB
      LACC LACC 7.4 0.1 0.1 0.1
      0.0 0.0 PASS PASS PASS PASS
      PASS PASS


      INSULATION RESISTANCE TESTS

      IRAE IRBE IRABA IRBBA IRAB
      LACC LACC LACC LACC 8113K
      10000K >10000K >10000K >10000K PASS
      PASS PASS PASS PASS


      CAPACITANCE MEASUREMENTS

      CAE CBE CAB BRK
      LACC LACC 4428 NO
      68 72


      NT LOOPBACK TEST
      PASS


      NT DC SIGNATURE TEST

      V-HIGH V-LOW
      83.920K LACC
      PASS >10000K
      PASS

      NT CONNECTED
      INV


      CIRCUIT TEST RESULT
      FAIL

      I need to get the o/p as:
      FVAELACC=0.0 FVBELACC=0.0 FVAB=7.4 FVAE=0.1 FVBE=0.1 FVAB=0.1
      CAELACC=68 CBELACC=72 CAB=4428
      NT CONNECTED=INV..

      Thanks in advance.