title: Parsing currency into a number in Spoon CSV Text Input
body: <p>This seems like it should be simple. </p>
  
  <p>I have a CSV file with multiple currency values (so I'd like to avoid writing a bunch of string-manipulation steps if it can be avoided), and I was excited to see that the CSV File Input step has fields like Currency Separator, decimal symbol, grouping symbol (and mine are the default "$", ".", and ",", respectively). </p>
  
  <p>The documentation describes these as for:</p>
  
  <ul>
  <li>Currency Used to interpret numbers like $10,000.00 or E5.000,00</li>
  <li>Decimal   A decimal point can be a "." (10;000.00) or "," (5.000,00)</li>
  <li>Grouping  A grouping can be a dot "," (10;000.00) or "." (5.000,00)</li>
  </ul>
  
  <p>(<a href="http://wiki.pentaho.com/display/EAI/Text+File+Input" rel="nofollow">http://wiki.pentaho.com/display/EAI/Text+File+Input</a>)</p>
  
  <p>But as of the current production version (4.4)... these settings do not seem to have an effect. </p>
  
  <p>Has anyone had success with number masks or similar such that a string like "$10,000,238.48" can yield a number that can be pushed into a database? Anything I do is either "Unparsable" in the text input or "truncated field" error at the insert...</p>