Pattern matching

USING ('/udb/udbsi001/temp01/udbsi001/TEMPSPACE1/CONT1',
                '/udb/udbsi001/temp01/udbsi001/TEMPSPACE1/CONT2',
                '/udb/udbsi001/temp01/udbsi001/TEMPSPACE1/CONT3',
                '/udb/udbsi001/temp01/udbsi001/TEMPSPACE1/CONT4')
         USING (FILE '/udb/udbsi001/index01/udbsi001/RGC/sibbdstr/sbdstridx'55360,
                FILE '/udb/udbsi001/index02/udbsi001/RGC/sibbdstr/sbdstridx'55360,
                FILE '/udb/udbsi001/index03/udbsi001/RGC/sibbdstr/sbdstridx'55360)
         USING (FILE '/udb/udbsi001/index01/udbsi001/RGC/sibborg/sborgidx'500,
                FILE '/udb/udbsi001/index02/udbsi001/RGC/sibborg/sborgidx'500,
                FILE '/udb/udbsi001/index03/udbsi001/RGC/sibborg/sborgidx'500)
         USING (FILE '/udb/udbsi001/index01/udbsi001/RGC/sibbpol/sbpolidx'18431544,
                FILE '/udb/udbsi001/index02/udbsi001/RGC/sibbpol/sbpolidx'18431544,
                FILE '/udb/udbsi001/index03/udbsi001/RGC/sibbpol/sbpolidx'18431544)
         USING (FILE '/udb/udbsi001/index01/udbsi001/RGC/sibbprod/sbprodidx'317744,
                FILE '/udb/udbsi001/index02/udbsi001/RGC/sibbprod/sbprodidx'317744,
                FILE '/udb/udbsi001/index03/udbsi001/RGC/sibbprod/sbprodidx'317744)
         USING (FILE '/udb/udbsi001/index01/udbsi001/RGC/sibbstag/sbstagidx'702704,
                FILE '/udb/udbsi001/index02/udbsi001/RGC/sibbstag/sbstagidx'702704,
                FILE '/udb/udbsi001/index03/udbsi001/RGC/sibbstag/sbstagidx'702704)
 

I need an o/p like the following

only within the single quotes

/udb/udbsi001/temp01/udbsi001/TEMPSPACE1/CONT1
/udb/udbsi001/temp01/udbsi001/TEMPSPACE1/CONT2
/udb/udbsi001/temp01/udbsi001/TEMPSPACE1/CONT3
/udb/udbsi001/temp01/udbsi001/TEMPSPACE1/CONT4
/udb/udbsi001/index01/udbsi001/RGC/sibbdstr/sbdstridx55360
/udb/udbsi001/index02/udbsi001/RGC/sibbdstr/sbdstridx55360
/udb/udbsi001/index03/udbsi001/RGC/sibbdstr/sbdstridx55360
/udb/udbsi001/index01/udbsi001/RGC/sibborg/sborgidx500
/udb/udbsi001/index02/udbsi001/RGC/sibborg/sborgidx500
/udb/udbsi001/index03/udbsi001/RGC/sibborg/sborgidx500
/udb/udbsi001/index01/udbsi001/RGC/sibbpol/sbpolidx18431544
/udb/udbsi001/index02/udbsi001/RGC/sibbpol/sbpolidx18431544
/udb/udbsi001/index03/udbsi001/RGC/sibbpol/sbpolidx18431544
/udb/udbsi001/index01/udbsi001/RGC/sibbprod/sbprodidx317744
/udb/udbsi001/index02/udbsi001/RGC/sibbprod/sbprodidx317744
/udb/udbsi001/index03/udbsi001/RGC/sibbprod/sbprodidx317744
/udb/udbsi001/index01/udbsi001/RGC/sibbstag/sbstagidx702704
/udb/udbsi001/index02/udbsi001/RGC/sibbstag/sbstagidx702704
/udb/udbsi001/index03/udbsi001/RGC/sibbstag/sbstagidx702704

Kindly provide the correct code.

What have you tried so far?

I've not tried anything. I was going through the SED tutorial how to extract things which is between the single quotes. Not deriving anything as of now.

Try not to extract things between single quotes, which, btw, would not yield your sample output. Try to suppress/eliminate/remove everything outside those quotes, and then, remove the quotes themselves.

Try this: This is for only within the single quotes.

awk -F"'" '{print $2}' inputfile

Note that the output you mentioned also contains piece outside the single quotes.
If that is the case, then I agree with what RudiC said.