Hi All
I am trying to remove the line having specific pattern from a file by using sed command
I have the file named ODS_REP_SRCE_File.txt with content as:
"FOLDR=$Path;FILE=$0;SRCDB=$ODS_REP_SRCE;SRCTBL=AP_INVC_DETL_F_V,AP_INVC_DETL_F_V,AP_CHECK_F_V,AP_INVC_PYMT_DTL_F_V;TGTDB=$EDW_TARGT;TGTTBL=AP_INVC_DETL_FS;JOBID=N/A;LOADTYP=DAILY;SRVPROCID=$$;TS=$QB_TS;"`
$ODS_REP_SRCE.AP_INVC_F_V
$ODS_REP_SRCE.AP_INVC_FX_V
$ODS_REP_SRCE.AP_INVC_FX_V
$ODS_REP_SRCE.AP_INVC_FX_V
$ODS_REP_SRCE.AP_INVC_F_V
$ODS_REP_SRCE.GCD_CURR_MAIN_D_V
$ODS_REP_SRCE.GCD_CURR_MAIN_D_V
$ODS_REP_SRCE.ORG_MAIN_D_V
$ODS_REP_SRCE.GCD_CURR_MAIN_D_V
$ODS_REP_SRCE.GCD_CURR_MAIN_D_V
$ODS_REP_SRCE.GCD_CURR_RT_HIST_F_V
$ODS_REP_SRCE.GCD_CURR_RT_HIST_F_V
$ODS_REP_SRCE.GCD_CURR_RT_HIST_F_V
$ODS_REP_SRCE.GCD_CURR_RT_HIST_F_V
$ODS_REP_SRCE.AP_INVC_F_V
$ODS_REP_SRCE.AP_INVC_FX_V
$ODS_REP_SRCE.AP_INVC_FX1_V
I am using the below code:
sed '/$DB_Name\;/d' ODS_REP_SRCE_File.txt
where $DB_Name value as ODS_REP_SRCE so my search pattern is "ODS_REP_SRCE;"
But the output is not deleting the 1st line which match the pattern.
Please let me Know how to handle this scenario..
Thanks,