0403-057 Syntax error

I am getting the error :

rocfm/wls_subload/in/processed_files/tel_input_additional_checked_all_mandatory.txt: 0403-057 Syntax error at 
line 1 : `|' is not expected.
>>>>ALL MANDATORY FIELDS CHECKING IS SUCCESSFUL count is 0
 
rocfm/wls_subload/in/processed_files/tel_input_additional_checked_all_mandatory.txt: 0403-057 Syntax error at 
line 1 : `|' is not expected.
>>>>ALL MANDATORY FIELDS CHECKING IS SUCCESSFUL count is 0
rocfm/wls_subload/in/processed_files/tel_input_additional_checked_product_type_mandatory.txt: 0403-057 Syntax 
error at line 1 : `|' is not expected.
>>>>PRODUCT TYPE CHECKING IS SUCCESSFUL count is 0
 
error 1 : 
0403-057 Syntax error
error 2 : count =0

That files contains 4 records

The input file is as given below

vi rocfm/wls_subload/in/pro
onal_checked_product_type_mandatory.txt <
rocfm/wls_subload/in/processed_files/tel_input_additional_checked_product_type_mandatory.txt" 4 lines, 98 ch
aracters
[Press return to continue] 
7099440||A||C|1|||20091224
6043171||D||I|1|||20010601
2502467||||||||
70994421||||||||
~

script :

#!/usr/bin/ksh
# Filename: filter_subscribers_exist_only_in_tel_main.sh
# Function: to run all subscriber exist only in tel scripts
# Auther : # Location: rocfm/wls_subload/resources/step/main_scripts
#######################################
 
INPUT_GEN_PATH=rocfm/wls_subload/resources/syncsort/scripts/input_generation
tel_PATH=rocfm/wls_subload/resources/syncsort/scripts/phone_exist_tel
INPUT_FILE_PATH=rocfm/wls_subload/in
PR_FILE_PATH=rocfm/wls_subload/in/processed_files
 
echo "1. #>>>>>>REMOVING DUPLICATE SUBSCRIBERS#"
$INPUT_GEN_PATH/tel_input_remove_duplicates.sh
echo "1.finished #>>>>>>REMOVEDDUPLICATES FROM tel SUBSET# tel_input_remove_duplicates.sh"
 
echo "2. #>>>>>>CHECKING MANDATORY FIELDS IN SUBSET FILE#"
$INPUT_GEN_PATH/tel_input_check_all_mandatory.sh
echo "2. finished #>>>>>>CHECKED MANDATORY FIELDS IN tel SUBSET FILE# tel_input_check_all_mandatory.sh"
chmod 777 $PR_FILE_PATH/tel_input_checked_all_mandatory.txt
COUNT_MAND_SUBSET=`$PR_FILE_PATH/tel_input_checked_all_mandatory.txt | wc -l`
if [ $COUNT_MAND_SUBSET -gt 0 ]; then
echo ">>>>>MANDATORY FIELDS ARE NOT HAVING VALUES OR INVALID VALUES count is $COUNT_MAND_SUBSET"
else 
echo ">>>>ALL MANDATORY FIELDS CHECKING SUCCESSFUL count is $COUNT_MAND_SUBSET" 
fi
echo "3. #>>>>>>FILTERING ACTIVE AND SUSPENDED SUBSCRIBERS IN SUBSET FILE#"
$INPUT_GEN_PATH/tel_input_act_and_susp_phones.sh
echo "3. finished #>>>>FILTERED ACTIVE AND SUSPENDED SUSBCRIBERS FROM SUBSET# tel_input_act_and_susp_phones.sh"
echo "4. #>>>>>>FILTERING CANCELLED SUBSCRIBERS IN SUBSET FILE#"
$INPUT_GEN_PATH/tel_input_cancelled_phones.sh
echo "4. finished #>>>>>>FILTERED CANCELLED SUBSCRIBERS FROM SUBSET# tel_input_cancelled_phones.sh"
echo "5. #>>>>>>REMOVING DUPLICATE SUBSCRIBERS FROM FULL SET FILE#"
$INPUT_GEN_PATH/tel_input_additional_remove_duplicates.sh
echo "5. finished #>>>>>>REMOVED DUPLICATES FROM FULL SET# "
 
echo "6. #>>>>>>REMOVING EMPTY SUBSCRIBERS IN FULL SET FILE#"
$INPUT_GEN_PATH/tel_input_additional_remove_empty.sh
echo "6. finished #REMOVED EMPTY SUBSCRIBERS IN FULL SET# tel_input_additional_check_all_mandatory.sh"
 
echo "7. #>>>>>>CHECKING ALL MANDATORY FIELDS IN FULL SET FILE#"
$INPUT_GEN_PATH/tel_input_additional_check_all_mandatory.sh
echo "7. finished #>>>>CHECKED ALL MANDATORY FIELDS IN FULL SET# tel_input_additional_check_all_mandatory.sh"
echo "8. #>>>>>>CHECKING PRODUCT TYPE FIELDS IN FULL SET FILE#"
$INPUT_GEN_PATH/tel_input_additional_check_product_type_mandatory.sh
echo "8. finished #>>>>CHECKED MANDATORY PRODUCT TYPE ADDITIONAL FIELDS IN FULL SET# tel_input_additional_check_product_type_mandatory.sh"
chmod 777 $PR_FILE_PATH/tel_input_additional_checked_all_mandatory.txt
COUNT_MAND_FULLSET=`$PR_FILE_PATH/tel_input_additional_checked_all_mandatory.txt|wc -l`
if [ $COUNT_MAND_FULLSET -gt 0 ]; then
echo ">>>>>MANDATORY FIELDS ARE NOT HAVING VALUES count is $COUNT_MAND_FULLSET"
else 
echo ">>>>ALL MANDATORY FIELDS CHECKING IS SUCCESSFUL count is $COUNT_MAND_FULLSET" 
fi
chmod 777 $PR_FILE_PATH/tel_input_additional_checked_product_type_mandatory.txt
COUNT_MAND_PRTYPE=`$PR_FILE_PATH/tel_input_additional_checked_product_type_mandatory.txt | wc -l`
if [ $COUNT_MAND_PRTYPE -gt 0 ]; then
echo ">>>>>PRODUCT TYPE IS HAVING INVALID VALUE count is $COUNT_MAND_PRTYPE"
else 
echo ">>>>PRODUCT TYPE CHECKING IS SUCCESSFUL count is $COUNT_MAND_PRTYPE" 
fi
echo "9. #>>>>>>FILTERING ACTIVE AND SUSPENDED SUBSCRIBERS FROM FULL SET FILE#"
$INPUT_GEN_PATH/tel_input_additional_act_susp_phones.sh
echo "9. finished #>>>>>SELECTED ACTIVE AND SUSPENDED RECORDS FROM ADDITIONAL# tel_input_additional_act_susp_phones.sh"
 
echo "################## finished input file generation for tel from RCODS#################"
 
 
echo "10. #>>>>>>REMOVING DUPLICATE SUBSCRIBERS FROM ROCFM FILE#"
$INPUT_GEN_PATH/rocfm_input_remove_duplicates.sh
echo "10. finished #REMOVED DUPLICATES FROM ROCFM# rocfm_input_remove_duplicates.sh"
echo "11. #>>>>>>FILTERING ACTIVE AND SUSPENDED SUBSCRIBERS FROM ROCFM FILE#"
$INPUT_GEN_PATH/rocfm_input_act_and_susp_phones.sh
echo "11. finished #FILTERED ACTIVE AND SUSPENDED SUSBCRIBERS IN ROCFM# rocfm_input_act_and_susp_phones.sh"
echo "12. #>>>>>>FILTERING CANCELLED SUBSCRIBERS FROM ROCFM FILE#"
$INPUT_GEN_PATH/rocfm_input_cancelled_phones.sh
echo "12. finished #FILTERED CANCELLED SUBCRIBERS FROM ROCFM# rocfm_input_cancelled_phones.sh"
echo "################## finished input file generation for ROCFM from NIKKIRA DB#################"
 
 
echo "################## finished input file generation #################"
 
echo "13. #>>>>>>FILTERING SUBSCRIBERS THAT EXIST ONLY IN tel -RCODS DB ,NOT IN NIKKIRA/ROCFM#"
$tel_PATH/phones_only_in_tel_filter.sh
echo "13. finished #FILTERED SUBSCRIBERS THAT EXIST ONLY IN tel# phone_only_tel_filter.sh"
echo "14. #>>>>>>REMOVING DUPLICATE SUBSCRIBERS AFTER FILTERING#"
$tel_PATH/phones_only_tel_remove_duplicates.sh
echo "14. finished #REMOVED DUPLICATES AFTER FILTER SUSBCRIBERS# phones_only_tel_remove_duplicates.sh"
echo "15. #>>>>>>ADDING ADDITIONAL 43 FIELDS TO SUBSET FILE#"
$tel_PATH/phones_only_in_tel_add_additionals.sh
echo "15. finished #ADDED ADDITIONAL FIELDS TO FINAL FILE# phones_only_in_tel_additionals.sh"
 
 
echo "################## finished SUBSCRIBERS EXIST ONLY IN tel , YOU CAN FIND FINAL PRODUCT IN rocfm/wls_subload/out/phones_exist_only_in_tel_fullset_final.txt#################"
 
#exit $?

can you please help me

Thanks

This code is trying to execute your date file:

COUNT_MAND_FULLSET=`$PR_FILE_PATH/tel_input_additional_checked_all_mandatory.txt|wc -l`

Change it to this:

COUNT_MAND_FULLSET=`wc -l $PR_FILE_PATH/tel_input_additional_checked_all_mandatory.txt`

My files are located in UNIX Server, i want to extract file_id and file_name from each file .and save it in a CSV file. How do I do that?
I have folders in unix environment, directory structure is structured as follows
year folder -> inside 12 months folders -> inside 30/31 days folders

I ran ls command folder
year as follows
2009 2010 2011 2012
I ran cd command for year 2012

$ cd 2012 

I ran ls command for 2012 year folder

$ ls 
01 02 03 04 05 06 07 08 09 

then I ran command for september

$ cd 09 
$ ls 
01 02 03 04 05 06 07 08 09 10 11 12 13 
$ cd 13 
$ ls 
sasmm_fsbc_durds_id00020532_t20100313192606.dat.trnsfr.gz 
sasmm_fsbc_durds_id00020513_t20120913003312.dat.trnsfr.gz 

there are folders for each year like 2009,2010,2011 and 2012
and folder has 12 folders for each months like 01,02,03,04,05,06,07,08,09,10,11,12
and each month folder has 31 folders for days like 1,2,3, etc... 29,30,31

inside each day folder has files..
the file name is as follows,

sasmm_fsbc_durds_id00020532_t20100313192606.dat.trnsfr.gz 
sasmm_fsbc_durds_id00020513_t20120913003312.dat.trnsfr.gz 

I want to have one csv file and that file needs to have two columns , one is for file_id and
second field is for file name.
to obtain file_id value ,loop through each folders and get file name, then read file name and
get substring between "sasmm_fsbc_durds_id000" and _t and store it in file_id column and store
file name in file_name column.

in above example for file sasmm_fsbc_durds_id00020532_t20100313192606.dat.trnsfr.gz
read file name sasmm_fsbc_durds_id00020532_t20100313192606.dat.trnsfr.gz
cut 20532 and save it in a file_id clumn and the whole file name in second column = sasmm_fsbc_durds_id00020532_t20100313192606.dat

CSV file will look like

file_id           file_name 
20532           sasmm_fsbc_durds_id00020532_t20100313192606.dat 
20513           sasmm_fsbc_durds_id00020513_t20120913003312.dat 

file_id is to be cut from the file name , if you look at the file name closely, you can see;
after 000 , file_ids in above file name examples , they are 20532 and 20513.

How do I loop through year 2012 and 12 months folders and 31 days folders inside it and create
csv file which has data as shown above?
I am very new unix, please help me out.. If you provide a code , that would be great..
thanks..

output CSV file look like this

file_id           file_name 
20532           sasmm_fsbc_durds_id00020532_t20100313192606.dat 
20513           sasmm_fsbc_durds_id00020513_t20120913003312.dat

To keep the forums high quality for all users, please take the time to format your posts correctly.

First of all, use Code Tags when you post any code or data samples so others can easily read your code. You can easily do this by highlighting your code and then clicking on the # in the editing menu. (You can also type code tags

```text
 and 
```

by hand.)

Selective use of color to highlight a single word or phrase can be useful at times, but large blocks of color, in general, makes the forums harder to read, especially bright colors like red.

Third, be careful when you cut-and-paste, edit any odd characters and make sure all links are working property.

Thank You.

The UNIX and Linux Forums