This discussion is archived
5 Replies Latest reply: Jan 28, 2013 4:35 AM by Rahul_India RSS

Help in writing SQL query

982895 Newbie
Currently Being Moderated
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.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points