O'Reilly Answers

Topics: validation

Feed Subscription    Email Subscription

Please sign in or register to post.

Please sign in or register to post.

• Geocoding and Data Checking 436,106 Addresses

  

  By kiwitobes : 30 October 2009 - 04:33 PM

  We had a project where, when we first looked at the data, we thought it would be really important to geocode 436,106 unique addresses. That is, we wanted to associate a latitude and longitude wit...

  Tags:

  • data
  • validation
  • geocoding

  3Votes

  1Comment

  ---

• How to Tell a User Added Your Facebook App

  

  By Jay Goldman : 29 October 2009 - 01:04 PM

  If you need to check whether a user has added my app, use the Users.isAppAdded⁠(⁠ ⁠) method:$hasAdded = $facebook->api_client->users_isAppAdded();Users.isAppAdded⁠(⁠ ⁠) re...

  Tags:

  • community
  • social media
  • facebook
  • apps
  • validation

  0Votes

  0Comments

  ---

• Highlight Invalid Worksheet Data in Excel

  

  By CurtFrye : 13 October 2009 - 02:59 PM

  I provide IT support for a building supply company, and one of my prime responsibilities is maintaining a spreadsheet with lots of customer information, including credit limits. Over the last six mont...

  Tags:

  • excel
  • validation

  1Vote

  0Comments

  ---

• How to Avoid Duplicate Entries in a Column with Excel

  

  By CurtFrye : 12 October 2009 - 12:15 PM

  I take inbound calls at a tech-support center, and we track the various callers by recording their phone number in a spreadsheet. The number of different callers is supposedly vital information, and m...

  Tags:

  • excel
  • formula
  • validation
  • duplicates

  0Votes

  0Comments

  ---

• Use Data in Another Worksheet as Validation Criteria

  

  By adfm : 08 October 2009 - 08:48 AM

  If you've ever wondered how to use data from one worksheet to validate another, then this excerpt from Excel Annoyances should help. I have the names of all 50 states in the U.S., plus the Dist...

  Tags:

  • validation
  • excel

  0Votes

  0Comments

  ---

• How to Restrict Data Entry with Validation Rules in Excel

  

  By CurtFrye : 29 September 2009 - 09:35 AM

  I'm a manager at an engineering company, and I hired an out-of-work political science major to do data entry and other clerical stuff. We don't pay him a lot, but our deal is that he gets to learn abo...

  Tags:

  • rules
  • zip code
  • validation
  • excel

  0Votes

  0Comments

  ---

• How to validate URLs with regular expressions

  

  By Jan Goyvaerts : 28 September 2009 - 11:03 AM

  If you want to check whether a given piece of text is a URL that is valid for your purposes, you can try one of the following solutions: Allow almost any URL: ^(https?|ftp|file)://....

  Tags:

  • regex
  • URL
  • validation

  0Votes

  0Comments

  ---

• How to use a custom validation object with JavaScript

  

  By dannyg1 : 02 September 2009 - 12:38 PM

  Use the code in the example below as a model for designing a single object that contains methods for each of your validation routines. The example uses modern event techniques for the form element'...

  Tags:

  • validation
  • forms
  • browser
  • javascript

  1Vote

  0Comments

  ---

• How to prevent form submission upon validation failure with JavaScript

  

  By dannyg1 : 02 September 2009 - 10:05 AM

  Batch validation checking typically operates from the submit event handler of the form element. Submission is aborted if the event handler evaluates to return false. Include the return statement in th...

  Tags:

  • validation
  • submission
  • forms
  • javascript
  • browser

  0Votes

  0Comments

  ---

• How to perform common text field validations with JavaScript

  

  By dannyg1 : 02 September 2009 - 09:49 AM

  Apply the library of text field validation routines shown in the Discussi on (Example A, “Backward-compatible text field validation functions” and Example B, “Text f...

  Tags:

  • javascript
  • text field
  • validation
  • forms
  • browser

  0Votes

  0Comments

  ---