I have 2 data set filea fileb
filea fileb
filename filename
a1 b1
a2 b2
a3 b3
a4 b4
a5 b5
a6 b6
a7 b7
a8 b8
I have to exstact data from unix as per filename
below mention path
x>y>z>a1>l
-rwxrwxr-x 1 x binary 173922 Feb 8 07:20 a1_07-02-2011_status. log
-rwxrwxr-x 1 x binary 173922 Feb 9 05:18 a1_08-02-2011_status. log
-rwxrwxr-x 1 x binary 173922 Feb 10 05:35 a1_09-02-2011_status. log
-rwxrwxr-x 1 x binary 173922 Feb 11 05:41 a1_10-02-2011_status. log
-rwxrwxr-x 1 x binary 173922 Feb 12 08:31 a1_11-02-2011_status. log
x>y>z>a2>l
-rwxrwxr-x 1 x binary 173922 Feb 8 07:20 a2_07-02-2011_status. log
-rwxrwxr-x 1 x binary 173922 Feb 9 05:18 a2_08-02-2011_status. log
-rwxrwxr-x 1 x binary 173922 Feb 10 05:35 a2_09-02-2011_status. log
-rwxrwxr-x 1 x binary 173922 Feb 11 05:41 a2_10-02-2011_status. log
-rwxrwxr-x 1 x binary 173922 Feb 12 08:31 a2_11-02-2011_status. log
x>y>z>b1>l
-rwxrwxr-x 1 x binary 173922 Feb 8 07:20 b1_07-02-2011_status. log
-rwxrwxr-x 1 x binary 173922 Feb 9 05:18 b1_08-02-2011_status. log
-rwxrwxr-x 1 x binary 173922 Feb 10 05:35 b1_09-02-2011_status. log
-rwxrwxr-x 1 x binary 173922 Feb 11 05:41 b1_10-02-2011_status. log
-rwxrwxr-x 1 x binary 173922 Feb 12 08:31 b1_11-02-2011_status. log
I need to create a data set filec which is like
filec
filename
a1_07-02-2011_status
a1_08-02-2011_status
a1_09-02-2011_status
a1_10-02-2011_status
a1_11-02-2011_status
a2_07-02-2011_status
a2_08-02-2011_status
a2_09-02-2011_status
a2_10-02-2011_status
a2_11-02-2011_status
b1_07-02-2011_status
b1_08-02-2011_status
b1_09-02-2011_status
b1_10-02-2011_status
b1_11-02-2011_status
Please help me
... View more