search for File

Swapna173 · 08-12-2008, 12:42 AM

Hi Guys,

I have a US_MFg_Units_On_Hand_Actual_2008_08_F.dat file where the file suffix changes everytime depending on the month and year. Now, i have a ctl file named US_MFg_Units_On_Hand_Actual.ctl for the same. Now depending on the .dat file i need to search for the corresponding .ctl file of it.

I was trying it will sql query but was not able to
select dsdas_table_name from configuration_master where source_file_name like '
select lower(substr('US_MFg_Units_On_Hand_Actual_2008_08_F',0,23)) from dual;

since here i am not able to know where to insert % sign to get the .ctl file name which is stored in database as well as in the linux machine.

So i thought there might be some way in linux to get the same.

Swapna

chrism01 · 08-12-2008, 01:10 AM

Are you trying to see if the ctl file is in the DB?
Sounds like Oracle, in which case, iirc the SQL is (similar to this)

select 1
from configuration_master
where source_file_name = 'US_MFg_Units_On_Hand_Actual.ctl';

If you get NULL, the rec is not there.

In Linux you can check the disk:

Code:

var=`ls US_MFg_Units_On_Hand_Actual.ctl 2>/dev/null|wc -l`
if [[ $var -eq 0 ]]
then
    echo "$file exists"
else
    echo "Nope"
fi

Swapna173 · 08-12-2008, 01:22 AM

Hi Chris,

My Question is to get the <<somefile>>.ctl depending on the <<somefile_suffix>>.dat. It is sure that i will have .ctl file. I need to get the .ctl on the basis of .dat file and the problem is my dat file name has suffix. but not my ctl file. I am having more than 1 ctl and dat files in the same folder.

I need to search "US_MFg_Units_On_Hand_Actual.ctl" file name from the folder when I have "US_MFg_Units_On_Hand_Actual_2008_08_F.dat" file.

Swapna

chrism01 · 08-12-2008, 02:11 AM

just to clarify, in Unix filename terms,

'US_MFg_Units_On_Hand_Actual' is the filename, 'ctl' is the suffix
'US_MFg_Units_On_Hand_Actual_2008_08_F' is filename, 'dat' is the suffix

anyway:

Code:

>s="US_MFg_Units_On_Hand_Actual_2008_08_F.dat"
>v=${s:0:27}
>echo $v
US_MFg_Units_On_Hand_Actual

>c=${v}.ctl
>echo $c
US_MFg_Units_On_Hand_Actual.ctl

See http://tldp.org/LDP/abs/html/string-manipulation.html