Hello guys,
I have a list of files. For example:
Code:
/disk1/mediator_home/tmp/ntest/TSFILE00.8256.GGG1-U.0908250009.unp.20090824P8.is
/disk1/mediator_home/tmp/ntest/TSFILE00.8257.GGG1-U.0908250013.unp.20090825P1.is
/disk1/mediator_home/tmp/ntest/TSFILE00.8257.GGG1-U.0908250013.unp.20090824P8.ic
/disk1/mediator_home/tmp/ntest/TSFILE00.8256.GGG1-U.0908250009.unp.20061116P1.is
/disk1/mediator_home/tmp/ntest/TSFILE00.8257.GGG1-U.0908250013.unp.20090825P1.ic
/disk1/mediator_home/tmp/ntest/TSFILE00.8256.GGG1-U.0908250009.unp.20321116P1.is
/disk1/mediator_home/tmp/ntest/TSFILE00.8257.GGG1-U.0908250013.unp.20090824P8.is
/disk1/mediator_home/tmp/ntest/TSFILE00.8257.GGG1-U.0908250013.unp.20061116P1.is
/disk1/mediator_home/tmp/ntest/TSFILE01.2009.08.23.00181910.unp.20090823P1.ic
/disk1/mediator_home/tmp/ntest/TSFILE01.2009.08.23.00111909.unp.20090823P1.ic
/disk1/mediator_home/tmp/ntest/TSFILE01.2009.08.23.00111909.unp.20090822P8.ic
/disk1/mediator_home/tmp/ntest/TSFILE00.8256.GGG1-U.0908250009.unp.20090825P1.is
/disk1/mediator_home/tmp/ntest/TSFILE00.8254.GGG1-U.0908250002.unp.20090824P8.is
/disk1/mediator_home/tmp/ntest/TSFILE01.2009.08.23.00051908.unp.20090822P8.ic
/disk1/mediator_home/tmp/ntest/TSFILE01.2009.08.23.00051908.unp.20090823P1.ic
/disk1/mediator_home/tmp/ntest/TSFILE00.8255.GGG1-U.0908250005.unp.20090824P8.is
I need to get list of unique characters from the last, like this:
substring (s, length(s) - 13, 10)
For example: above output is:
Code:
20061116P1
20090822P8
20090823P1
20090824P8
20090825P1
20321116P1
Please help,
Thanks in advance