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,170 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

What code do you have in TextZeroFormat function?

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

Like (0)

Report
Copy link

Link copied!
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
Copy link

Link copied!

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,170 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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
Copy link

Link copied!

Then replace the function call with FORMAT(Amount);

Was this reply helpful? Yes No
Suggested answer

keoma 32,729 on at

Like (0)

Report
Copy link

Link copied!

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