Useful Regex for CSV to SQL [relevance: 3.16]

As a point of reference

how to convert a comma delimited file to an SQL insert
Assuming your data is the following

'key','value','0'
'key','value','1'

In notepad++ the syntax for search and replace would be as follows:
search: ('[^']+','[^']+','[^']+')
replace: (\1)
syntax varies depending on the flavour of regex

which can then have an insert statement added and...:
insert into table (key_value, value_blah, personal_id)
values
('key','value','0')
('key','value','1')

deleteing columns in Textpad
INSERT INTO "IB_RESOURCE_MESSAGE" (IB_MESSAGE_ID,IB_VALUE,IB_KEY,IB_BUNDLE_ID) VALUES (0,'Welcome #{identity.username}','loginSucceeded',0)

to delete the first value column (1, .... use the following
([0-9]+,
the plus will search for recurring instances of the pattern [0-9]

search for DHCP servers on a network - dhclient [relevance: 2.82]

If you wish to search for DHCP servers on a network just type:
dhclient [interface]
and it will bring back information on all running DHCP servers on your subnet

MySQL full indexed text search - just like a real database!! [relevance: 2.77]

• As of My Sql 3.something you can now add text indexes to your columns and do full text searches with relevance ranking! text indexes are fantastic and allow more efficient searching and categorisation of text. The relevance ranking feature is rather good too and gives you a much better idea of how your search performed. 
•  
• Issues to note are, this example uses relevance ranking as the criteria for returning results, if you take that condition out you will return every result in the database with a relevance score of 0. 
•  
• The default MySQL settings do not bother to index search terms of less than 4 characters therefore searching for anything less will bring back no results. This can be altered by setting "set ft_min_word_len =1" in your mysql config. This will result in a performance hit.  
•  
• Text indexes in large data sets can be quite processor intensive so you might also consider limiting your result set. 
•  
• ALTER TABLE `database`.`table_name` 
• ENGINE = MyISAM; 
•  
• ALTER TABLE table_name 
• MODIFY column_name TEXT; 
•  
• ALTER TABLE table_name 
• ADD FULLTEXT(column_name); 
•  
• SELECT *, 
• MATCH(column_name) 
• AGAINST ('search term') 
• AS score 
• FROM table_name 
• HAVING score > 0 
• ORDER BY score DESC;

Command Line Web Browser [relevance: 1.89]

If need to browse the world wide web and you are either running in an ssh window or you really hate the whole web 2 thing.. help is at hand

Centos
yum install lynx

Debian
apt-get intall lynx

run lynx then you can view this page like this...

icurtain - lights on the roundabout
[H] Blog IDAT205 IDAT204 IDAT203 IDAT201 AINT204 SOFT221 ISAD223 SOFT218 Linux JSF PHP Java[EE] Java[J2ME] SQL submit search for..________
Centos NFS Install

2008-06-04 11:41:15 digg this!

Download the Centos Boot image
Download the Centos DVD image and save it on an NFS enabled share on your lan

Install with Network boot CD

choose to boot: linux text

Choose Manual IPv4
192.168.1.* / 255.255.255.0
192.168.1.*
192.168.1.*

(NORMAL LINK) Use right-arrow or to activate.
Arrow keys: Up and Down to move. Right to follow a link; Left to go back.
H)elp O)ptions P)rint G)o M)ain screen Q)uit /=search [delete]=history list

references and grouped searches in textpad regex [relevance: 1.81]

when you group searches in the textpad regex editor you have to escape the grouping brackets with a backslash otherwise it searches them as literal characters

for example:
\([0-9]\) will search for any number 0-9
but if you omit the the escape slash it will look for (1) for example