Add:
Code
Short description
Tags

Like: create mysql user Like: mysql, bash, server

public

add it or cancel

IMPORTANT!

Snipt is going open source. We've toyed with this idea for quite a while, and have finally decided it's the right way to move forward.

A few things:

The entire Snipt source code will be released on GitHub under the 3-clause BSD License on Friday, September 10th.
While we'd like to think we're perfect, we realize we're only human. By open sourcing the software that runs this website, certain bugs or security flaws may be discovered that could compromise the privacy of your snipts.
Only the Lion Burger team will be able to push commits to the Snipt.net site. Contributors should send a pull request to add new features or submit patches.
By using this site, you agree not to be too angry or take any legal action against Lion Burger should this whole thing go up in flames some day.
Follow us on Twitter for updates.

I agree, close this message

Latest 100 public snipts » terramar's snipts

showing 1-9 of 9 snipts

∞ Format phone numbers in spreadsheet
```
="("&MID(A2,1,3)&") "&MID(A2,4,3)&"-"&MID(A2,7,4)
```
```
text
```
1

Format phone numbers in spreadsheet
```
="("&MID(A2,1,3)&") "&MID(A2,4,3)&"-"&MID(A2,7,4)
```
copy | embed

0 comments - tagged in
- format,
- phone numbers,
- spreadsheet
posted by terramar on Mar 12, 2010 at 4:59 p.m. EST
∞ Concatenate first and last name
```
=B10&", "&C10
```
```
text
```
1

Concatenate first and last name
```
=B10&", "&C10
```
copy | embed

0 comments - tagged in
- concatenate,
- excel,
- names
posted by terramar on Jan 20, 2010 at 1:26 a.m. EST

∞ Javascript image replacement based on class name

<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.3/jquery.min.js"></script>
<script type="text/javascript">

 $(document).ready(function() {
  var tcells = document.getElementsByTagName("td");
  for (i=0;i<tcells.length;i++) {
   var tcell = tcells.item(i);
   if (tcell.className == "status") {
    if (tcell.innerHTML == "Open") tcell.innerHTML = '<img src="/image/open.gif" />';
     else if (tcell.innerHTML == "Closed") tcell.innerHTML = '<img src="/images/open.png" />';
   }
  }
  return false;
 });
</script>

js

<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.3/jquery.min.js"></script>
<script type="text/javascript">

 $(document).ready(function() {
  var tcells = document.getElementsByTagName("td");
  for (i=0;i<tcells.length;i++) {
   var tcell = tcells.item(i);
   if (tcell.className == "status") {
    if (tcell.innerHTML == "Open") tcell.innerHTML = '<img src="/image/open.gif" />';
     else if (tcell.innerHTML == "Closed") tcell.innerHTML = '<img src="/images/open.png" />';
   }
  }
  return false;
 });
</script>

copy | embed

0 comments - tagged in

posted by terramar on Dec 29, 2009 at 2:38 p.m. EST

∞ Find duplicate entries in a spreadsheet
```
=IF(B2=B1,"DUPL","")
```
```
text
```
1

Find duplicate entries in a spreadsheet
```
=IF(B2=B1,"DUPL","")
```
copy | embed

0 comments - tagged in
- duplicates,
- excel,
- spreadsheet
posted by terramar on Dec 22, 2009 at 5:00 p.m. EST
∞ Generate formatted phone number for use in spreadsheets (e.g. 1111111111 to (111) 111-1111)
```
="("&LEFT(L3,3)&") "&MID(L3,4,3)&"-"&RIGHT(L3,4)
```
```
text
```
1

Generate formatted phone number for use in spreadsheets (e.g. 1111111111 to (111) 111-1111)
```
="("&LEFT(L3,3)&") "&MID(L3,4,3)&"-"&RIGHT(L3,4)
```
copy | embed

0 comments - tagged in
- format,
- phone number,
- spreadsheet
posted by terramar on Jun 28, 2009 at 4:27 a.m. EDT
∞ Creates selectable area all around text
```
#navigation li a    { display:block; }
```
```
css
```
1

Creates selectable area all around text
```
#navigation li a    { display:block; }
```
copy | embed

0 comments - tagged in
- navigation
posted by terramar on May 21, 2009 at 1:47 a.m. EDT

∞ Attribute Specific Icons

a[href$='.pdf'] { padding:0 20px 0 0; background:transparent url(/graphics/icons/pdf.gif) no-repeat center right; }

css

a[href$='.pdf'] { padding:0 20px 0 0; background:transparent url(/graphics/icons/pdf.gif) no-repeat center right; }

copy | embed

0 comments - tagged in

icons

posted by terramar on May 21, 2009 at 1:45 a.m. EDT

∞ IE6 PNG Transparency

* html img,
* html .png {
position:relative;
behavior: expression((this.runtimeStyle.behavior="none")&&(this.pngSet?this.pngSet=true:(this.nodeName == "IMG" && this.src.toLowerCase().indexOf('.png')>-1?(this.runtimeStyle.backgroundImage = "none",
this.runtimeStyle.filter = "progid:DXImageTransform.Microsoft.AlphaImageLoader(src='" + this.src + "', sizingMethod='image')",
this.src = "transparent.gif"):(this.origBg = this.origBg? this.origBg :this.currentStyle.backgroundImage.toString().replace('url("','').replace('")',''),
this.runtimeStyle.filter = "progid:DXImageTransform.Microsoft.AlphaImageLoader(src='" + this.origBg + "', sizingMethod='crop')",
this.runtimeStyle.backgroundImage = "none")),this.pngSet=true)
);
}

css

* html img,
* html .png {
position:relative;
behavior: expression((this.runtimeStyle.behavior="none")&&(this.pngSet?this.pngSet=true:(this.nodeName == "IMG" && this.src.toLowerCase().indexOf('.png')>-1?(this.runtimeStyle.backgroundImage = "none",
this.runtimeStyle.filter = "progid:DXImageTransform.Microsoft.AlphaImageLoader(src='" + this.src + "', sizingMethod='image')",
this.src = "transparent.gif"):(this.origBg = this.origBg? this.origBg :this.currentStyle.backgroundImage.toString().replace('url("','').replace('")',''),
this.runtimeStyle.filter = "progid:DXImageTransform.Microsoft.AlphaImageLoader(src='" + this.origBg + "', sizingMethod='crop')",
this.runtimeStyle.backgroundImage = "none")),this.pngSet=true)
);
}

copy | embed

0 comments - tagged in

posted by terramar on Feb 28, 2009 at 11:48 p.m. EST

∞ Horizontal CSS (<li>) Navigation

#navigation ul {
	margin: 0px;
	padding: 0px;
	font-family: Verdana,arial;
	font-size: 14px;
	font-weight: bold;
	color: white;
	white-space: nowrap;
}

#navigation li {
	list-style-type: none;
	display: inline;
	margin: 0px;
	padding-right: 40px;
}

#navigation li a {
	text-decoration: none;
	color: white;
}

#navigation li a:link {
	text-decoration: none;
	color: white;
}

#navigation li a:visited {
	text-decoration: none;
	color: white;
}

#navigation li a:hover {
	text-decoration: none;
	color: #99cc00;
}

css

#navigation ul {
	margin: 0px;
	padding: 0px;
	font-family: Verdana,arial;
	font-size: 14px;
	font-weight: bold;
	color: white;
	white-space: nowrap;
}

#navigation li {
	list-style-type: none;
	display: inline;
	margin: 0px;
	padding-right: 40px;
}

#navigation li a {
	text-decoration: none;
	color: white;
}

#navigation li a:link {
	text-decoration: none;
	color: white;
}

#navigation li a:visited {
	text-decoration: none;
	color: white;
}

#navigation li a:hover {
	text-decoration: none;
	color: #99cc00;
}

copy | embed

0 comments - tagged in

css,
navigation

posted by terramar on Feb 27, 2009 at 4:08 p.m. EST

Latest 100 public snipts » terramar's snipts

terramar's tags