My ED table contains a value with one decimal space (separated with point) that originates from an excel sheet.
When I use the Cell(x,y,atom) 4DScript command, the command returns a value without a point but the string does contain a point?! (see image).
Does anyone have an idea how this is possible?
Inconsistent table read
-
- Posts: 14
- Joined: Tuesday 29 March, 2011 - 09:12
Inconsistent table read
- Attachments
-
- Untitled-1.png (324.93 KiB) Viewed 3460 times
- HarryBunnik
- Posts: 362
- Joined: Monday 07 February, 2011 - 11:22
Re: Inconsistent table read
Dear enterprisedynamics,
I've had similar problems once and that was related to the copying of my data from Excel. It turned out that behind the data (the 10.8) some spaces were copied along. This resulted in ED interpreting the data as a string, and skipping the "." from the value.
I hope this helps you further,
Cheers,
Harry
I've had similar problems once and that was related to the copying of my data from Excel. It turned out that behind the data (the 10.8) some spaces were copied along. This resulted in ED interpreting the data as a string, and skipping the "." from the value.
I hope this helps you further,
Cheers,
Harry
-
- Posts: 14
- Joined: Tuesday 29 March, 2011 - 09:12
Re: Inconsistent table read
Harry,
This is exactly the case with my cells.
Your answer saved me a lot of time! Thanks.
This is exactly the case with my cells.
Your answer saved me a lot of time! Thanks.