Skip to main content
  • EN

I'm reading an HTML table from a website and its bringing in both Real64 and Real32 numbers which I'm writing to a Geodatabase table. No matter if I specify column types of Float, Double, or Integer I get unwanted results where the number has a comma separator in the thousandth position (From table) - the resulting number adds a period in the output. Some of the numbers are dropping a zero when the number ends with zero: 8450 becomes 845. Has anyone experienced this before?

Hi @gary, how about removing commas from the number? You can use the StringReplacer to remove all commas from a string with this setting.

  • Mode: Replace Text
  • Text to Replace: ,
  • Replacement Text: <not set>

 

 

@takashi Thank you, that did the trick. I had looked at the StringReplacer before but for some reason had got different results.

Reply


Community Stats

30,112
Posts
114,305
Replies
37,743
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.