Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
replace "10.10.20.[1-8] 80" with "10.10.20.9 8[*]" in record
Ta muchly, just what I needed... I've ended up with; { if ($3 ~ /10.10.20.[1-8]/) { fldnum = substr($3,10,1) $3 = substr($3,1,9) "9" $4 = substr($4,1,1) fldnum } print $0 } Works a treat... -
Limiting rows returned
Presume you're paging? Its not too easy to start from, with a limit without running through a CURSOR, unless you know what the row, or keyed order you're starting from. If you do then you can either select top 10 ... from ... order by 'key' where 'key' > known_value or ; set rowcount 10...- dbad
- Post #3
- Forum: Microsoft SQL Server: Programming
-
replace "10.10.20.[1-8] 80" with "10.10.20.9 8[*]" in record
I'm parsing some logs and need to replace a string with a wildcard match with another string, while still maintaining the 'wildcard'. e.g. line: blah1 blah2 10.10.20.1 80 blah5 blah6 needs to look like; line: blah1 blah2 10.10.20.9 81 blah5 blah6 (delimited by space, would prefer not to rip...
