Search Results

But I don't what to create new cache file.....I want to find matching files in it and delete it....may be using some for loops...

hi,

i have a cache file with below file list
more gtda_11.cache
GTDA_Dly_Pmix_GB_6_20130624.20130624070610.psv
GTDA_Dly_Pmix_CH_006_20130624.20130624140018.psv...

thanks a lot Akshay!!

i am using this command awk -F "_" '{$(NF--)=""; print}' filelist.xls
GIDW Dly Pmix PL 0 0
GIDW Dly Pmix PL 0 0
GIDW Dly Sls IT 0 0
GIDW Dly Sls IT 0 0
GIDW Dly Sls legacy RO 0 0
GIDW Dly Sls...

perl -pe 's/_[0-9]{14}.csv\n/ /g' filelist.xls
GIDW_Dly_Pmix_PL_0_0 GIDW_Dly_Pmix_PL_0_0 GIDW_Dly_Sls_IT_0_0 GIDW_Dly_Sls_IT_0_0 GIDW_Dly_Sls_legacy_RO_0_0 GIDW_Dly_Sls_legacy_RO_0_0...

yes i want only list of of names in the a .xls file ....i need it for renaming process ....so i will fect the names of files and add current timestamp to all the files using for loop ...

Hi,


i have below list of files so i just want the name of the files in one parameter and not the timestamp.
i want only GIDW_Dy_Tm_Seg_Sls_legacy_PL_0_0_ in variable of all files.

...

more GTDA_UNMATCHED_FILES.dat
GTDA_Dly_Pmix_ES_140_20131001.20131018025152.psv
GTDA_Dly_Pmix_ES_140_20131001.20131018025154.psv
GTDA_Dly_Pmix_ES_140_20131001.20131018025156.psv...

But columns in both the for are different in one for i am removing 18,19 and in other for i am removing 12,13...so how can i use same for for both...

---------- Post updated at 05:22 PM ----------...

Hi,

i have below code so i want to run only one for loop instead of two.

if [ $SLS_COUNT -gt 0 ]; then
FILE_NAME_SLS=`cat $FILE_PATH|grep 'GTDA_Dly_Sls_'`
...

/dm/RMDW_LandingZone/dev/work_area/ABaC_reregister> ls -l | grep GTDA
-rwxrwxrwx 1 mc25730 dstage 242 2013-10-15 04:18 file_GTDA.xls

/dm/RMDW_LandingZone/dev/work_area/ABaC_reregister> more...

hi,

i tried this command it is giving below error:
ls -ld GTDA_Dly_Sls_SS_136_20130917.20130917205418.psv
/bin/ls: cannot access GTDA_Dly_Sls_SS_136_20130917.20130917205418.psv: No such file or...

@pravin: files are in file_GTDA.xls and in same path.

/dm/RMDW_LandingZone/dev/work_area/ABaC_reregister> more file_GTDA.xls
GTDA_Dly_Pmix_AT_136_20130917.20130917205418.psv...

grep -Fxvf testdata.xls file_GTDA1.xls >file_GTDA.xls

SLS_COUNT=`grep 'GTDA_Dly_Sls' file_GTDA.xls |wc -l`
PMIX_COUNT=`grep 'GTDA_Dly_Pmix' file_GTDA.xls |wc -l`

if [ $SLS_COUNT -gt 0 ]; then...

This is .xls which contains list of files so i want to read this xls file and want to search specific files in it.

Hi,

i want to search different file pattern in .xls and then perform particular operation on it. But my below command is not working in code


if [`cat file_GLMA.xls|grep 'GLMA_Dly_Pmix'|wc...

oppss!! sorry

i want to export data from teradata to linux file through fastload scriPT.
but my teradata table has column which cotains timestamp so i want to export only two day old (current_date -2) data using...

hi,
i want to remove 12 and 13 column from psv files and dump them in new folder

ls -ltr *GTDA_Dly_Pmix_*.psv>filename.xls

var1=`cat filename.xls`

for i in $var1
do
var3=`echo "$i" |cut...