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?
Userlevel 2
+17
- Contributor
- 7539 replies
-
18 March 2020
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
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.