Wednesday, March 18, 2020
Tip of the Day: GATEWAY IMPORT Parameter to Handle Percentages
Product.......: R:BASE X.5 and R:BASE X.5 Enterprise (Version 10.5)
Build.........: 10.5.2.20312 or higher
Sections......: Commands
Keywords......: Import, XLS, XLSX, Percentage, PERCENT_MODE
Did you know a new GATEWAY IMPORT parameter for the XLS format was
added to handle percentages stored in cells?
Because the XLS and XLSX formats treat percentage values in cells
differently (9.5 vs 0.095), a new GATEWAY IMPORT parameter, named
PERCENT_MODE, was added to the GATEWAY IMPORT XLS import to handle
percentages stored in cells.
- PERCENT_MODE <DEFAULT|100|RAW>
DEFAULT - default behavior. "9.5" for XLS and "0.095" for XLSX.
100 - output is "9.5" . The stored value is multiplied by 100.
RAW - output is "0.095" (percentage are really raw decimals)
Example:
GATEWAY IMPORT XLS +
Jan2020-City-Rates.xlsx REPLACE +
tTaxTableImport +
OPTION SHEET_INDEX 0 +
|AUTONUM OFF +
|FIRST_ROW 7 +
|LAST_ROW 3000 +
|SHOW_PROGRESS ON +
|MESSAGES ON +
|PERCENT_MODE RAW +
|ERROR_FILE EXCEPT.DAT
RETURN
Very Best R:egards,
Razzak.
https://www.rbase.com
http://www.facebook.com/rbase/
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google Groups "RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/202003181519.02IFJrag050783%40atl4mhob22.registeredsite.com.
