+1Hello,
In my workspace, I use LenghtCalculator to have the "Distance" from line.
I'd like to have three Numbers after .
I use Stringformatter on this attribute with Format String .3f but all value not have this setting.
Someone can help me to fix this?
I have also tried Attribute Manager with Math Opérator "ROund (Distance, 3). It's the same things.
Best Regards
Best answer by mark2atsafe
I covered the answer to this question (I hope) in the question-of-the-week post here:
https://knowledge.safe.com/questions/113630/question-of-the-week-writing-fixed-length-numbers.html
I think the problem is partly each of these:
I hope this is helpful.
If I'm looking at the yellow highlight in the screenshot, it seems you want 0.11 formatted as 0.110?
If so, try this in a StringFormatter:
-0.3fIf I'm looking at the yellow highlight in the screenshot, it seems you want 0.11 formatted as 0.110?
If so, try this in a StringFormatter:
-0.3fThank you for your answer. I can have number like 1.110 , 2,130 etc..
Meanwhile I tested but It don't change anything. It's only data calculate with LengthCalculator
+1The AttributeRounder is the easiest way to do this.
Hope this helps.
Hello,
Thank for your help.
The AttributeRounder give me the same result. The problem is only with data calculate with Length calculator.
+1What version of fme are you using? .3f works for me
Hello Thank for your answer.
I have try with FME 2020.0 Build 20200 and FME 2020.0.2 Build 20232.
If i make like you , it also works for me, but not with my attribute Lg2D (m)
Thank you for your answer. I can have number like 1.110 , 2,130 etc..
Meanwhile I tested but It don't change anything. It's only data calculate with LengthCalculator
Regardless, if you write "1.110" to Excel, it will still show up in Excel as 1.11, as this is a formatting issue, not a value issue.
Basically you should probably solve this issue in the Excel cell formatting settings.
+1Regardless, if you write "1.110" to Excel, it will still show up in Excel as 1.11, as this is a formatting issue, not a value issue.
Basically you should probably solve this issue in the Excel cell formatting settings.
Yes I can modify the parameters in Excel and It works but FME must handle it.
My purpose it's manage and configure data with FME and not Excel to simplify the work.
The other value like 335.670 are formatting when we want (Print Screen 1)
The print screen 2 show the act of formatting in excel and the result (ex 0.970 or 6.980).
Is it possible, it's a bug in FME?
Print Screen 1
Print Screen 2
+2You can use the rounder with 3 places and then a StringPadder with desired length as 3, right pad, and 0 as the padding value. That will append a 0. But, the -0.3f should work.
Yes I can modify the parameters in Excel and It works but FME must handle it.
My purpose it's manage and configure data with FME and not Excel to simplify the work.
The other value like 335.670 are formatting when we want (Print Screen 1)
The print screen 2 show the act of formatting in excel and the result (ex 0.970 or 6.980).
Is it possible, it's a bug in FME?
Print Screen 1
Print Screen 2
It's difficult to say if it's a bug, because it works for my tiny test case. Are you able to post a minimal workspace here that demonstrates the issue?
+1You can use the rounder with 3 places and then a StringPadder with desired length as 3, right pad, and 0 as the padding value. That will append a 0. But, the -0.3f should work.
Hello,
Sorry, your solution doesn't work with my Workspace and Data :(
I'm starting to suspect that FME is trying too hard to be intelligent and preserve the input float datatype, so that when it sees 1.110 cast as a float, it displays as 1.11, because realistically, that's what it is.
Try chaining two StringFormatters together, the first one with format string "s" to force the float to a string-like representation, then the next with "-0.3f" for padding.
+34I'm starting to suspect that FME is trying too hard to be intelligent and preserve the input float datatype, so that when it sees 1.110 cast as a float, it displays as 1.11, because realistically, that's what it is.
Try chaining two StringFormatters together, the first one with format string "s" to force the float to a string-like representation, then the next with "-0.3f" for padding.
Wonder if it could be related to the attribute type preservation in 2020?
https://knowledge.safe.com/questions/112114/attribute-data-type-preservation-in-fme-2020.html
+1I'm starting to suspect that FME is trying too hard to be intelligent and preserve the input float datatype, so that when it sees 1.110 cast as a float, it displays as 1.11, because realistically, that's what it is.
Try chaining two StringFormatters together, the first one with format string "s" to force the float to a string-like representation, then the next with "-0.3f" for padding.
Hello.
I try your solution, but it doesn't work :(
+1Wonder if it could be related to the attribute type preservation in 2020?
https://knowledge.safe.com/questions/112114/attribute-data-type-preservation-in-fme-2020.html
Perhaps, but i have another attribute that i calculate with Arithmetic Editor and it's works.
+44I covered the answer to this question (I hope) in the question-of-the-week post here:
https://knowledge.safe.com/questions/113630/question-of-the-week-writing-fixed-length-numbers.html
I think the problem is partly each of these:
I hope this is helpful.
+1I covered the answer to this question (I hope) in the question-of-the-week post here:
https://knowledge.safe.com/questions/113630/question-of-the-week-writing-fixed-length-numbers.html
I think the problem is partly each of these:
I hope this is helpful.
Hello Mark
Thank for your answer.
The value is Always viewed as 0.11 in FME but I set up a Template Excel File where the number is defined as 3 decimals places and it's good.
Best Regards
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
