[SED] Parsing to get a single value


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting [SED] Parsing to get a single value
# 1  
Old 11-07-2011
[SED] Parsing to get a single value

Hello guys,

I guess you are fed up with sed command and parse questions, but after a while researching the forum, I could not get an answer to my doubt. I know it must be easy done with sed command, but unfortunately, I never get right syntax of this command

OK, this is what I have in my script:

Code:
stats=`$path_ds_ex/dsjob -linkinfo $proyecto $job $stage_IN $link_IN`

If I perform an echo over stats variable, this is what is shown:

Quote:
Link Row Count : 172372 Link Last Error : <none> Link DBMS Code : not available SQL State : not available Link Name : ENTRADA
What I need to obtain is the value marked in bold-red

I tried the following, but did not work:

Code:
numfilas=`echo $stats | sed 's/.*Link Row Count :\([^ ]*\).*/\1/' `

Thanks very much for your help
# 2  
Old 11-07-2011
Code:
sed 's/.* : \([0-9]\+\) .*/\1/'
# or
sed 's/^Link Row Count : \([0-9]\+\) .*/\1/'
# or
cut -d" " -f5

# 3  
Old 11-07-2011
@OP: In your
Code:
sed 's/.*Link Row Count :\([^ ]*\).*/\1/'

You left out a space after the :
Code:
sed 's/.*Link Row Count : \([^ ]*\).*/\1/'

# 4  
Old 11-07-2011
Quote:
Originally Posted by Scrutinizer
@OP: In your
Code:
sed 's/.*Link Row Count :\([^ ]*\).*/\1/'

You left out a space after the :
Code:
sed 's/.*Link Row Count : \([^ ]*\).*/\1/'

Arrghhh!!! What a lot of time wasted just because of a blank space! Smilie

In any case, thanks very much guys for your so fast help, this forum RULES!!!
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Parsing via sed issue

sorry I messed up the last post with too many mistakes and corrections so I closed it and opening a new one which should be clear to everyone .my apologies to the admins. I am using sun solaris and Linux , what I want is SED to print any string (or output it to a file preferably) that does... (2 Replies)
Discussion started by: boncuk
2 Replies

2. Shell Programming and Scripting

Parsing and masking regions from a single fasta file with subsequence

HI, I have a Complete genome fasta file and I have list of sub sequence regions in the format as : 4353..5633 6795..9354 1034..14456 I want a script which can mask these region in a single complete genome fasta file with the alphabet N kindly help (2 Replies)
Discussion started by: margarita
2 Replies

3. UNIX for Dummies Questions & Answers

sed or Grep Parsing

I would like to parse two strings from lines in a file only when both strings appear on the same line. For example, if I have the following line: string1 string2 string3 string4 string5 string6 string7 string8 string9 I would like the output to be: string2: string7 Can someone give me... (5 Replies)
Discussion started by: ARBlue79
5 Replies

4. Shell Programming and Scripting

Need help parsing data with sed and/or nawk

Good day all. I have the following entries of data in a file in a column, however, I need this data written on a single line with several parameters in a different order. Current format: Treatment ,parmeter1=value ,parmeter2=value ,parmeter3=value ,parmeter4=value... (7 Replies)
Discussion started by: BRH
7 Replies

5. Shell Programming and Scripting

Sed special parsing

What is the shortest & right way to remove the string "" with a sed statement ? echo 'whateverwhatever' | sed ........ ? :) (2 Replies)
Discussion started by: ctsgnb
2 Replies

6. Shell Programming and Scripting

sed (parsing value)

All, Can somebody provide me with some sed expertise on how to parse the following line. 27-MAR-2011 10:28:01 * (CONNECT_DATA=(SID=dmart)(CID=(PROGRAM=sqlplus)(HOST=mtasnprod1)(USER=mtasnord))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.197.7.47)(PORT=54881)) * establish * dmart * 0 I would like... (3 Replies)
Discussion started by: BeefStu
3 Replies

7. Shell Programming and Scripting

Parsing cron with sed

Hello I want to convert my cron list into a csv Can you please help me with sed ? eg: Convert #06,21,36,51 * * 1,2 * (. ~/.profile ; timex /some/path/script -30 -15) >> /some/path/logfile2 2>&1 * * * * * (. ~/.profile ; timex /some/path/script2) > /some/path/logfile2 To:... (1 Reply)
Discussion started by: drbiloukos
1 Replies

8. Shell Programming and Scripting

Parsing with awk or sed

I want to delete corrupt records from a file through awk or sed. Can anyone help me with this Thanks Striker Change subject to a descriptive one, ty. (1 Reply)
Discussion started by: Rahul_us
1 Replies

9. Shell Programming and Scripting

Sed parsing error

I'm having a problem with a sed script. A programmer needs to change columns 942,943,944 to blank spaces only where it has the number 999 in every line. I didn't have a copy of the data file to test with originally so made my own up with a bunch of x's and put 999 in columns 5-7. The sed... (1 Reply)
Discussion started by: gravy26
1 Replies

10. Shell Programming and Scripting

awk sed parsing

hi , i would like to parse some file with the fallowing data : data data data "unwanted data" data data "unwanted data" data data data data #unwanted data. what i want it to have any coments between "" and after # to be erased using awk or/and sed. has anyone an idea? thanks. (3 Replies)
Discussion started by: Darsh
3 Replies
Login or Register to Ask a Question