Recent content by macubergeek

Wow thanks guys I'm on target now I gotta grok regular expressions better.... **runs to re read regex book jim

Sorry perhaps I was unclear This is the output I want: when I do arp -a I get this kind of output: 192.168.1.1 192.168.1.5 192.168.1.100 192.168.1.101 192.168.1.255 Now I'm thinking this is a simple regex find and delete. I'm just uncertain how to match ( and ) and replace with empty string.

when I do arp -a I get this kind of output: (192.168.1.1) (192.168.1.5) (192.168.1.100) (192.168.1.101) (192.168.1.255) All I want to do is to remove the parens and keep the ip address. I've tried this with sed and gotten nowhere. sed 's/\(//g'

Thanks it was the Where statement I was messing up.

I have this query against database nessus table results: select count(risk) as "Subtotals:",risk as "Risk Level" from results group by risk; select count(risk) as "Subtotals:",risk as "Risk Level" from results group by risk; and it returns: Subtotals: Risk Level 36 2 304...

Ok here's my code: foreach $line (@aonly) { print FH $line,$item,'WHAT SETTING SHOULD BE:'; chomp $line; } problem is I miss the first line I get: yayayayayaya What Setting Should be: yayayayaya What Setting Should be: ababababab What Setting Should be: xxxxxxxxxx What Setting Should be:

I tried your suggestion. It does this: blah blah blah blah blah blah blah blah blah is not in compliance but I'm trying to do: blah blah blah is not in compliance blah blah blah is not in compliance blah blah blah is not in compliance how would I do that?

I currently have a script that works fine. It loads file A into an array. It then searches for each line in @A in file B. It then reports back to me which lines in @A that id DOESN'T find in file B. I'm printing out these results with: print FH (@aonly, $item); ------------------------- The...

The problem is you have not assigned a password to the root account. Mysqld won't start up with a blank root password. do: $mysqladmin -u root -p Enter password: <enter the root password you want here> <enter> then as root do: mysqld_safe & this will start the mysqld server. Depending on how...

lgarner and TonyGroves, thanks! Some how I was stuck in the SELECT syntax format. DELETE from <tablename> worked fine.

I'm trying to figure out the sql syntax to delete every row from a specified table. I don't want to drop the table just clean out every row... I've tried: DELETE * FROM TABLE_NAME; DELETE * FROM TABLE_NAME WHERE id NOT NULL; no luck. Can someone give me a shove in the right direction?

**slapping forehead** thanks

From experimenting, I've found that (?) and ? both work. Does anyone know if it's possible to pass more than one placeholder? Say I want to specify two or more terms in the SELECT statement can I use ? and ?1? or some other form of multiple placeholders inside the SQL query?

erickbrunson good point thanks

hmmm let me try that stevexff, thanks!