Learn the fundamentals of Angular 2, a JavaScript framework for developing dynamic single page applications.
Format a decimal to string
I didnt develop this code. I want to modify the last line.
The promodsc will be a negative number with decimal value. I want to eliminate the sign and decimal. For example promodsc is -4.99. I want it change to 499. The rest of command will give me 0000000499+ string I need. What do I need to change here?
REPLACE TAX_AMT WITH RIGHT("0000000000" + ALLTRIM(B->TAXTOTAL),10) + "+"
REPLACE FRT WITH RIGHT("0000000000" + ALLTRIM(B->SHIPTOTAL),10) + "+"
REPLACE BPAY_TYP WITH "04"
REPLACE DISC_AMT WITH RIGHT("0000000000" + ALLTRIM(b->promodsc),10) + "+"
The promodsc will be a negative number with decimal value. I want to eliminate the sign and decimal. For example promodsc is -4.99. I want it change to 499. The rest of command will give me 0000000499+ string I need. What do I need to change here?
REPLACE TAX_AMT WITH RIGHT("0000000000" + ALLTRIM(B->TAXTOTAL),10) + "+"
REPLACE FRT WITH RIGHT("0000000000" + ALLTRIM(B->SHIPTOTAL),10) + "+"
REPLACE BPAY_TYP WITH "04"
REPLACE DISC_AMT WITH RIGHT("0000000000" + ALLTRIM(b->promodsc),10) + "+"
Do more with
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
The VFP Function STR() will convert a Numeric to a String.
If you look in your VFP Help for that funcion you will see it described in detail.
Another VFP function which may work for you is the TRANSFORM() function.
Again look into your VFP Help for more explanation
Lastly if you want to Pad out the string value to a fixed number of digits you will likely want to use the PADL() or PADR() function (see your VFP Help)
Note that since you seem to want to change the numeric value (example: from -4.99 to 499) I'd recommend doing that (maybe in a temporary cursor) PRIOR to converting the value to a String.
Perhaps something like:
nTestValue = -4.99
nNewTestValue = ((-1 * nTestValue) * 100)
cNewTestValue = ALLTRIM(STR(nNewTestValue)
cNewTestValue = PADL(cNewTestValue,10,'0')
If you have questions about any individual line, look up the function in your VFP Help.
Good Luck
If you look in your VFP Help for that funcion you will see it described in detail.
Another VFP function which may work for you is the TRANSFORM() function.
Again look into your VFP Help for more explanation
Lastly if you want to Pad out the string value to a fixed number of digits you will likely want to use the PADL() or PADR() function (see your VFP Help)
Note that since you seem to want to change the numeric value (example: from -4.99 to 499) I'd recommend doing that (maybe in a temporary cursor) PRIOR to converting the value to a String.
Perhaps something like:
nTestValue = -4.99
nNewTestValue = ((-1 * nTestValue) * 100)
cNewTestValue = ALLTRIM(STR(nNewTestValue)
cNewTestValue = PADL(cNewTestValue,10,'0')
If you have questions about any individual line, look up the function in your VFP Help.
Good Luck
I use this command.
REPLACE DISC_AMT WITH PADL(ALLTRIM(STRTRAN(STR(A
Resulting error message..
Function argument value,type or count is invalid.
REPLACE DISC_AMT WITH PADL(ALLTRIM(STRTRAN(STR(A
Resulting error message..
Function argument value,type or count is invalid.
PADL(ALLTRIM(STRTRAN(STR(A
Resulting error message..
Function argument value,type or count is invalid.
In order to determine which part of your command is causing the error message, break it down into is pieces and review the results.
?ABS(b.promodsc)
?STR(ABS(b->promodsc),99,2
* --- I think your problem is here since I don't see the 2nd 'change to' parameter above ---
?STRTRAN(STR(ABS(b->promod
? ALLTRIM(STRTRAN(STR(ABS(b-
?PADL(ALLTRIM(STRTRAN(STR(
Good Luck
Resulting error message..
Function argument value,type or count is invalid.
In order to determine which part of your command is causing the error message, break it down into is pieces and review the results.
?ABS(b.promodsc)
?STR(ABS(b->promodsc),99,2
* --- I think your problem is here since I don't see the 2nd 'change to' parameter above ---
?STRTRAN(STR(ABS(b->promod
? ALLTRIM(STRTRAN(STR(ABS(b-
?PADL(ALLTRIM(STRTRAN(STR(
Good Luck
Probably the problem is that your data type is character and I assumed it was numeric. Try this:
PADL(ALLTRIM(STRTRAN(STR(A
jrbbldr: omitting the 2nd parameter is quite alright.
PADL(ALLTRIM(STRTRAN(STR(A
jrbbldr: omitting the 2nd parameter is quite alright.
If indeed the value of b.promodsc was a character instead of a numeric (as suggested above by: example promodsc is -4.99) then by breaking the complex code down to its most simple components in a step-by-step manner would show you specifically where the problem existed.
For example if you should try the following on a Character value, you will get an error message which is telling you that the value cannot be run within the ABS() function.
?ABS(b.promodsc)
Good Luck
For example if you should try the following on a Character value, you will get an error message which is telling you that the value cannot be run within the ABS() function.
?ABS(b.promodsc)
Good Luck
If the field type of b.promodsc is character, then you obviously do not need to do the Functions which relate to Numeric values.
Instead you can get rid of the minus sign (a character) merely by using STRTRAN() or CHRTRAN()
And you can also get rid of the decimal point (a character) by using STRTRAN() or CHRTRAN()
Good Luck
Instead you can get rid of the minus sign (a character) merely by using STRTRAN() or CHRTRAN()
And you can also get rid of the decimal point (a character) by using STRTRAN() or CHRTRAN()
Good Luck
Premium Content
You need an Expert Office subscription to comment.Start Free Trial