Sponsored Content
Top Forums Shell Programming and Scripting Extraction problem with sed command Post 302949095 by Shilpi Gupta on Tuesday 7th of July 2015 06:10:48 AM
Old 07-07-2015
Extraction problem with sed command

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:

Code:
"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:

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,
Moderator's Comments:
Mod Comment Please use CODE tags for sample input and output as well as for code segments.

Last edited by Don Cragun; 07-07-2015 at 03:52 PM.. Reason: Add data CODE tags.
 

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

sed command problem

I am cating a file with passwords into another file. I want to replace the the password with **** and it is not working. Here is my command cat testing | sed 's/`echo ${pass}`/*****/'>>out1 ${pass} is the password that I want to replace before it goes into out1 Anyone know what I am... (1 Reply)
Discussion started by: lesstjm
1 Replies

2. Shell Programming and Scripting

SED scipt help - line extraction

Forgive me if this is a dumb question...I'm a Windows sys admin with little programming knowledge. I have files containing anywhere from 3 to 200 lines. Using SED, I want to extract only lines containing a specific instance of "ISS." It is possible that "ISS" will occur several times in a... (10 Replies)
Discussion started by: thuston22
10 Replies

3. Shell Programming and Scripting

Sed/awk gods, I need your Help! Fancy log extraction

Hi! I'm trying to find a way to extract a certain amount of lines from a log file. This would allow me to "follow" a web user through our log files. Here is a sample fake log file to explain what i want to accomplish : BEGIN REQUEST sessionID=123456 boatload of lines for thread-1 detailing... (8 Replies)
Discussion started by: gnagus
8 Replies

4. Shell Programming and Scripting

extraction of samba shares with sed

Hi there, My samba configuration file looks like that : ... ... path = /home/samba/profiles/ ... path = /home/samba/shares/family valid users = family path = /home/samba/shares/admins valid users = admins path = /home/samba/shares/publicI want to extract the list of standard... (3 Replies)
Discussion started by: chebarbudo
3 Replies

5. Shell Programming and Scripting

Extraction of text using sed or awk command

Hi All, I need to extract 543 from the command below : # pvscan PV /dev/sdb1 VG vg0 lvm2 Total: 1 543.88 GB] / in use: 1 / in no VG: 0 I have the following command which does the job, but I think this could be achieved in a more simple way using sed or awk. Any help is... (7 Replies)
Discussion started by: nua7
7 Replies

6. Shell Programming and Scripting

Obscure sed extraction syntax

Hi, Could anyone clearly explain me the below sed construct in detail to get to know what it actually does? sed 's/\(* *\)//4' echo 'test;10;20' | sed 's/*;\(*\)/\1/' (1 Reply)
Discussion started by: royalibrahim
1 Replies

7. UNIX for Dummies Questions & Answers

awk/sed match and extraction

Hi, I have a file like this- aa 12 23 34 aa 21 34 56 aa 78 45 56 I want to print out only the lines after the last aa. How do I do this? I tried using grep -A and sed -n, but both didnt work as I wanted to. Could someone help me out please.. (3 Replies)
Discussion started by: jamie_123
3 Replies

8. Shell Programming and Scripting

sed text extraction between 2 patterns using variables

Hi everyone! I'm writting a function in .bashrc to extract some text from a file. The file looks like this: " random text Begin CG step 1 random text Begin CG step 2 ... Begin CG step 100 random text" For a given number, let's say 70, I want all the text between "Begin CG... (4 Replies)
Discussion started by: radudownload
4 Replies

9. UNIX for Dummies Questions & Answers

sed command problem

Hi i am reading a tutorial on sed below command was given in tutorial. i am not able to understand the working of below command also this command is now working in my enviroment. $ sed -n '1~2p' alarm sed: 1: "1~2p": invalid command code ~ $ need your assitance here (7 Replies)
Discussion started by: scriptor
7 Replies
SHTOOL-SUBST.TMP(1)					      GNU Portable Shell Tool					       SHTOOL-SUBST.TMP(1)

NAME
shtool-subst - GNU shtool sed(1) substitution operations SYNOPSIS
shtool subst [-v|--verbose] [-t|--trace] [-n|--nop] [-w|--warning] [-q|--quiet] [-s|--stealth] [-i|--interactive] [-b|--backup ext] [-e|--exec cmd] [-f|--file cmd-file] [file] [file ...] DESCRIPTION
This command applies one or more sed(1) substitution operations to stdin or any number of files. OPTIONS
The following command line options are available. -v, --verbose Display some processing information. -t, --trace Enable the output of the essential shell commands which are executed. -n, --nop No operation mode. Actual execution of the essential shell commands which would be executed is suppressed. -w, --warning Show warning on substitution operation resulting in no content change on every file. The default is to show a warning on substitution operations resulted in no content change on all files. -q, --quiet Suppress warning on substitution operation resulting in no content change. -s, --stealth Stealth operation. Preserve timestamp on file. -i, --interactive Enter interactive mode where the user has to approve each operation. -b, --backup ext Preserve backup of original file using file name extension ext. Default is to overwrite the original file. -e, --exec cmd Specify sed(1) command directly. -f, --file cmd-file Read sed(1) command from file. EXAMPLE
# shell script shtool subst -i -e 's;(c) ([0-9]*)-2000;(c) 1-2001;' *.[ch] # RPM spec-file %install shtool subst -v -n -e 's;^(prefix=).*;1 $RPM_BUILD_ROOT%{_prefix};g' -e 's;^(sysconfdir=).*;1 $RPM_BUILD_ROOT%{_prefix}/etc;g' `find . -name Makefile -print` make install HISTORY
The GNU shtool subst command was originally written by Ralf S. Engelschall <rse@engelschall.com> in 2001 for GNU shtool. It was prompted by the need to have a uniform and convenient patching frontend to sed(1) operations in the OpenPKG package specifications. SEE ALSO
shtool(1), sed(1). 18-Jul-2008 shtool 2.0.8 SHTOOL-SUBST.TMP(1)
All times are GMT -4. The time now is 09:09 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy