troubleshooting Question
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) + "+"
Learn from the best
Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.
Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 3 Answers and 9 Comments.
Try for 7 days”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.
Our community of experts have been thoroughly vetted for their expertise and industry experience.