Removing leading zeros

(0) Share

Report

Posted on by Martinho Costa

779

Hi, I'm exporting a group of a decimal fields to txt and I'm getting those fields with leading zeros: 000000246 and the result I pretend is 246.
I did this funtion below and tried the same function with the parameters on DELCHAR and it didnt work.
Any tip?

DecimalNumeralZeroFormat(Amount,9)

//Respective Function

LOCAL DecimalNumeralZeroFormat(DecimalNumeral : Decimal;Length : Integer) : Text[250]
EXIT(TextZeroFormat(DELCHR(FORMAT(ROUND(ABS(DecimalNumeral),1,'<'),0,1)),Length));

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (1)

Mohana Yadav 61,005 Super User 2025 Season 2 on at

Like (0)

Report

What code do you have in TextZeroFormat function?

Was this reply helpful? Yes No
Martinho Costa 779 on at

Like (0)

Report
LOCAL TextZeroFormat(Text : Text[250];Length : Integer) : Text[250] IF STRLEN(Text) > Length THEN ERROR(Text003,Text,Length); EXIT(PADSTR('',Length - STRLEN(Text),'0') + Text);

Was this reply helpful? Yes No
Natalie Karolak - t... 1,955 on at

Like (0)

Report

I am unsure whether I got the point ...

What is your desired output, and what are you getting instead?

Was this reply helpful? Yes No
Verified answer

Mohana Yadav 61,005 Super User 2025 Season 2 on at

Like (0)

Report

TextZeroFormat function is adding the leading zeros.

Please try to change your code by removing above function

Was this reply helpful? Yes No
Natalie Karolak - t... 1,955 on at

Like (0)

Report

Then replace the function call with FORMAT(Amount);

Was this reply helpful? Yes No
Suggested answer

keoma 32,729 on at

Like (0)

Report

hi,

follow msdn.microsoft.com/.../dd354973.aspx for delchr function

and http://msdn.microsoft.com/en-us/library/dd301101.aspx for padstr function.

Was this reply helpful? Yes No