Search Results

... since you only look $1 you don't need to set complicated -F delimiter such as '\\|\\^' or "\\\|\\\^"
awk -F"|" '{print$1}' test_dlim.csv

awk -F '\\|\\^' '{print $1}' test_dlim.csv

Another solution which does not require the use of awk is

wordc=`wc -l < $file_path`

If your shell supports it the more modern syntax is:

wordc=$(wc -l < $file_path)

Please post the exact and complete script (within code tags) without anything else that may have been on the screen at the time.


One potential problem is with this line, but the output posted...

Hi,

must be space between echo and ""

else
echo "pass a valid parameter to shell"
echo "1 for INSERT into bckup_marc_parameter_lookup"
echo "2 for DELETE/INSERT into...

remove space before END

a=$1
if [ $a -eq 1 ]
then
sqlplus -s prospect_stg/prospect_stg@mdmpt <<END
insert into bckup_marc_parameter_lookup select * from...

with line leading TABs:

sqlplus -s prospect_stg/prospect_stg@mdmpt <<-END
prospect.marc_parameter_lookup;
commit;
exit;
...