Stripping Invalid Characters From Currency Numbers
When building interactive calculation forms, the form user is frequently required to enter currency amounts.
Currency symbols, commas, spaces, and other characters can wreak havoc with the calculation. The calculation fails, resulting in a script error, or the calculated result is incorrect.
Here is a way to strip invalid characters from string values for 3 different programming languages, Perl, PHP, and JavaScript. All characters except numbers and periods are removed from the value.
Perl:
#!/usr/bin/perl
use strict;
print "Content-type:text/html\n\n<head><body>";
my $teststring = '$24,150.85';
print "Before: $teststring<br >";
$teststring =~ s/[^\d\.]//g;
print "After: $teststring";
PHP:
<?php
$teststring = '$24,150.85';
echo "Before: $teststring<br />";
if( preg_match('/[&\d\.]/',$teststring) ) { $teststring = preg_replace('/[^\d\.]/','',$teststring); }
echo "After: $teststring";
?>
JavaScript:
<script type="text/javascript">
var teststring = "$24,150.85";
alert("Before: " + teststring);
var re = /[^\d\.]/g;
teststring = teststring.replace(re,"");
alert("After: " + teststring);
</script>
Will Bontrager
Was this blog post helpful to you?
(anonymous form)
All information in WillMaster Blog articles is presented AS-IS.
We only suggest and recommend what we believe is of value.
As remuneration for the time and research involved to provide quality links,
we generally use affiliate links when we can.
Whenever we link to something not our own, you should assume
they are affiliate links or that we benefit in some way.
Recent Articles in the Library
Inspecting HTML Tags
Software to inspect meta and link tags that might have changed after the web page was loaded.
Linked Images in Facebook
Post a URL on Facebook. Facebook pulls in an image and links to that URL. (Probably similar on other social media sites.)
Real Download Link
A download link can tell the browser to download the file for saving on the user's hard drive — instead of displaying it in a browser window.
Characters for Hyphenation
The CSS hyphenate-character property can be used to tell the browser an alternate character or set of characters should be used where a hyphen would be inserted at end of lines.
Automatic Wrap Balancing for Headlines
Use the CSS text-wrap:balance; property to better balance the line lengths of multi-line headlines.
Redirect With Method POST
When you can't use method POST, but you must, read this.
Gradient-colored Text
The information you need to make color-gradient text.
