Ranorex is stripping off $ and add trailing 0s upon import
-
- Posts: 1
- Joined: Tue Oct 23, 2018 5:34 pm
Ranorex is stripping off $ and add trailing 0s upon import
Hi, I'm new to Ranorex. I'm trying to do a simple validation against a datasource where $5,900 and $0.00 appear on the UI; however, upon loading it into Ranorex, the Ranorex datasource is now displaying 5,900 and 0.0000 respectively.
- Support Team
- Site Admin
- Posts: 12145
- Joined: Fri Jul 07, 2006 4:30 pm
- Location: Houston, Texas, USA
- Contact:
Re: Ranorex is stripping off $ and add trailing 0s upon import
Hi CenteneUser2.0,
Based on the described issue, I suspect you are using Excel as your data source. Excel often automatically formats your data so it is easier to read, however, the actual value is different. In Excel, set the cell's format to "Text" or "General" to see the actual value.
I hope this helps!
Cheers,
Ned
Based on the described issue, I suspect you are using Excel as your data source. Excel often automatically formats your data so it is easier to read, however, the actual value is different. In Excel, set the cell's format to "Text" or "General" to see the actual value.
I hope this helps!
Cheers,
Ned
Re: Ranorex is stripping off $ and add trailing 0s upon import
I would highly recommend that you stop using Excel. Use CSV text files instead. They do not have this issue, and as long as you enclose the string in quotes like ("$45,000") (otherwise the comma would be a problem) you will be fine.
Shortcuts usually aren't...