|
|
Sponsored Content
Top Forums
Shell Programming and Scripting
NOT able to pickup files
Post 302523493 by shyamu544 on Thursday 19th of May 2011 03:33:10 AM
05-19-2011
NOT able to pickup files
Hi,
I have two files to pick and excute these ones.
File1
OLFIN.PRL_100.OIB.TLU.001.D20110510.T144948
File2OLFIN.PRM_100.OTU.001.D20100726.T050026
date '+%H:%M:%S'
SCRIPTS_PATH=/u/dolfin/bin
. ${SCRIPTS_PATH}/set_dolfin_env.sh
DATA_FILE_NAME=DATA_FILE
DATE_FORMAT=`date '+%Y%m%d'`
DATE_FORMAT=20110323
cd ${DOLFIN_IN_DIR}
# Try to get a data file matching the pattern and check if the data file exists or not
SAP_DATA_FILE=`ls DOLFIN.PR*_100*.001.D*.T* | egrep -e 'TLU|OTU'`
if [ ! -z "${SAP_DATA_FILE}" ]
then
echo "Found SAP data file ${SAP_DATA_FILE}"
cd ${DOLFIN_BIN_DIR}
i=0
for file in /u/dolfin/in/DOLFIN.PR*_100*.001.D*.T* | egrep -e 'TLU'
do
let i=i+1
SQL Load all the sap data from SAP_TUR into data management tables
sqlldr ${ORA_USER}/${ORA_PASSWD} control= /u/dolfin/bin/load_sap_credit_template.ctl bad=/u/dolfin/log/ data=$file
#move the processed data file to in_arc directory
mv $file ../in_arc
# Compress the data file
compress ../in_arc/$file
# echo $file archived
echo "Finished loading SAP data from TURKEY"
done
else
echo "No SAP data found for TURKEY!!!"
fi
date '+%H:%M:%S'
But getting error as
"load_sap_credit_data_oib_turkeynew1.sh[29]: syntax error at line 35 : `|' unexpected"
Reason is in the code
" for file in /u/dolfin/in/DOLFIN.PR*_100*.001.D*.T* | egrep -e 'TLU' "
This is invalid.
Could you please let us know replacing correct stmt in place of above code.
Appricate early response on this
I have two files to pick and excute these ones.
File1
OLFIN.PRL_100.OIB.TLU.001.D20110510.T144948File2
OLFIN.PRM_100.OTU.001.D20100726.T050026date '+%H:%M:%S'
SCRIPTS_PATH=/u/dolfin/bin
. ${SCRIPTS_PATH}/set_dolfin_env.sh
DATA_FILE_NAME=DATA_FILE
DATE_FORMAT=`date '+%Y%m%d'`
DATE_FORMAT=20110323
cd ${DOLFIN_IN_DIR}
# Try to get a data file matching the pattern and check if the data file exists or not
SAP_DATA_FILE=`ls DOLFIN.PR*_100*.001.D*.T* | egrep -e 'TLU|OTU'`
if [ ! -z "${SAP_DATA_FILE}" ]
then
echo "Found SAP data file ${SAP_DATA_FILE}"
cd ${DOLFIN_BIN_DIR}
i=0
for file in /u/dolfin/in/DOLFIN.PR*_100*.001.D*.T* | egrep -e 'TLU'
do
let i=i+1
SQL Load all the sap data from SAP_TUR into data management tables
sqlldr ${ORA_USER}/${ORA_PASSWD} control= /u/dolfin/bin/load_sap_credit_template.ctl bad=/u/dolfin/log/ data=$file
#move the processed data file to in_arc directory
mv $file ../in_arc
# Compress the data file
compress ../in_arc/$file
# echo $file archived
echo "Finished loading SAP data from TURKEY"
done
else
echo "No SAP data found for TURKEY!!!"
fi
date '+%H:%M:%S'
But getting error as
"load_sap_credit_data_oib_turkeynew1.sh[29]: syntax error at line 35 : `|' unexpected"
Reason is in the code
" for file in /u/dolfin/in/DOLFIN.PR*_100*.001.D*.T* | egrep -e 'TLU' "
This is invalid.
Could you please let us know replacing correct stmt in place of above code.
Appricate early response on this
|
|
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
Can any body help me,How to pickup file from folder using shellscript.
FolderName:/test
FileinFolder: test.txt
MY req is:Shellscript pickup file from folder and pass file as parameter to java program..?
Thanks,
Rams (0 Replies)
Discussion started by: ram2s2001
0 Replies
2. Shell Programming and Scripting
Freinds,
I need help:
I need to process number of flat files on weekly basis. My source dir will receive flat files regulary at mid night
between 1:00am and 6:00am. When I run my weekly file process it should get only the files which are until last friday
(including friday)and move them in... (1 Reply)
Discussion started by: magi
1 Replies
3. UNIX for Dummies Questions & Answers
How can I pickup files with a specific date by "ls" command without options? (1 Reply)
Discussion started by: gd2003
1 Replies
4. Shell Programming and Scripting
Hi I am going to migrate our datawarehouse system from HP Tru 64 Unix to the Red Hat Linux.
Inside the box, it is running around 40 cron jobs; inside each cron job, it is calling other shell script files, and the shell script files may again call other shell script files or ctl files(for... (1 Reply)
Discussion started by: franksubramania
1 Replies
5. Shell Programming and Scripting
Hi,
Could someone please assist on a quick way of How to extract data from indexed files (ISAM files) maintained in an UNIX(AIX) server.The file data needs to be extracted in flat text file or CSV or excel format .
Usually we have programs in microfocus COBOL to extract data, but would like... (2 Replies)
Discussion started by: devina
2 Replies
6. UNIX for Dummies Questions & Answers
the sorting is based on name of file,
file size
modification time stamps o f file
it should dislay the output in the following format
"." and ".." enteries should be ignored
please give some idea how to do it (1 Reply)
Discussion started by: pappu kumar jha
1 Replies
7. Shell Programming and Scripting
Hi Gurus,
I need to develop a script which picks the files in a pre-defined order.
The files from monday-friday will be named as abc_01_20130923 as monday's file and abc_02_20130924 as tuesday's..so..so forth till friday's which will be named as abc_05_20130927.It repeats over for the... (3 Replies)
Discussion started by: vikramgk9
3 Replies
8. Shell Programming and Scripting
I need a script file for backup (zip or tar or gz) of old log files in our unix server (causing the space problem). Could you please help me to create the zip or gz files for each log files in current directory and sub-directories also?
I found one command which is to create gz file for the... (4 Replies)
Discussion started by: Mallikgm
4 Replies
9. Shell Programming and Scripting
Hi experts,
I am facing a problem right now.I have to automate the pickup of files based on a priority.The scenario is as below:
1) There will be files from Mon-Fri with Mon file being named as abc_def_01_YYYYMMDD and Tue file being abc_def_02_YYYYMMDD and so forth till Friday's file which... (1 Reply)
Discussion started by: vikramgk9
1 Replies
10. UNIX for Beginners Questions & Answers
i use the split command to split a one terabyte backup file into 10 chunks of 100 GB each. The files are split one after the other. While the files is being split, I will like to scp the files one after the other as soon as the previous one completes, from server A to Server B. Then on server B ,... (2 Replies)
Discussion started by: malaika
2 Replies
LEARN ABOUT SUSE
ale
ALE(1) ALE(1) NAME
ale - a synthetic capture engine and renderer SYNOPSIS
ale [OPTIONS] original-frame [supplemental-frames ...] output-file ale [HELP OPTIONS] ale --version DESCRIPTION
ALE is a free software synthetic capture engine and renderer accepting, as input, a sequence of image frames, and producing, as output, rendered images, registration data, and 3D models (currently experimental). EXAMPLES
ale --hu Print the help page on program usage. ale 001.ppm 002.ppm 003.ppm out.ppm Render output file out.ppm from inputs 001.ppm, 002.ppm, and 003.ppm. ale --scale 2 001.ppm 002.ppm 003.ppm out.png Render output file out.png at 2x scale. ale --perturb-upper=0 --trans-load=a.t --projective frame*.png out.png Render output file out.png from inputs frame*.png, using projective transformations as described in the file a.t. ale --3dv 0 out.png --projective frame*.png null: Render output file out.png from inputs frame*.png, using a 3D scene model to determine transformations. ale --visp last:sinc*lanc:6 sf:0 out/ .jpg in/*.jpg null: Render a video stream from files in/*.jpg to the directory out/, stabilizing to the first frame, with a lanczos-windowed sinc filter. USAGE
ale is a wrapper script that calls the executable ale-bin after extracting exposure EXIF information from image files (when the exiftool utility is available) and converting from raw formats (when the dcraw utility is available). When ale-bin has been linked with ImageMagick, input and output files may be of any kind supported by ImageMagick. Otherwise, only PPM files can be read and written by ale-bin. OPTIONS
OPTIONS are summarized via built-in help pages (see HELP OPTIONS below). More detailed manuals describing options and internal algorithms are available for certain versions of ALE. See SEE ALSO below for more details on other manuals. HELP OPTIONS
A listing of available help options can be obtained by invoking ale --hu. ENVIRONMENT
The wrapper script ale recognizes the following environment variables: ALE_BIN ALE executable to use. DCRAW dcraw raw extraction tool to use. EXIF_UTILITY EXIF extraction utility to use. ALE_COUNT_THREADS Displays statistics on thread counts when set to a non-zero value. PAGER Text pager to use (e.g., for displaying help pages). SEE ALSO
More detailed manuals for certain versions of ALE are distributed with source packages, and may also be available from: http://auricle.dyndns.org/ALE/manuals/ 03/31/2009 ALE(1)