title: Unable to convert char array to decimal in the pig
body: <p>Hi I am new to pig programming. I have one csv file and tab as a delimiter. In my price column I have lacs and crores. It looks like this <code>40.85 Lacs</code>, <code>36.73 Lacs</code>, <code>2.01 cr</code>. I want to convert into decimal like this </p>
  
  <pre><code>40.85 Lacs - 40,85,000
  36.73 Lacs - 36,73,000
  2.01 cr - 2,01,00000
  </code></pre>
  
  <p>I tried the following code:</p>
  
  <pre><code>a = LOAD '/user/user1/input/city/cityname.CSV' using PigStorage('|') as (SourceWebSite:chararray,PropertyID:chararray,ListedOn:chararray,ContactName:chararray,TotalViews:int,Price:chararray,PriceperArea:chararray,NoOfBedRooms:int,NoOfBathRooms:int,FloorNoOfProperty:chararray,TotalFloors:int,Possession:chararray,BuiltUpArea:chararray,Furnished:chararray,Ownership:chararray,NewResale:chararray,Facing:chararray,title:chararray,PropertyAddress:chararray,NearByFacilities:chararray,PropertyFeatures:chararray,Sellerinfo:chararray,Description:chararray);
  DUMP a;
  b = FOREACH a GENERATE Price;
  dump b;
  c = FILTER b BY (Price matches '.*Lacs.*');
  d = FOREACH c GENERATE Price * 10000.0,SUBSTRING(Price,00000);
  d = foreach c generate Price,TOKENIZE(REPLACE(Price,'.','')) AS e;
  </code></pre>
  
  <p>I am struggling for two days in this. Any help will be appreciated.</p>