Skip to main content
simply more productive

The Data Specialist

Thanks to our intuitive transformation designer, you can convert data effortlessly to a variety of formats without knowing how to program. It’s not only efficient, it’s also easy to use.
Flowheater Chart

unnecessary zeros

  • FlowHeater-Team
  • avatar Topic Author
  • Offline
  • Admin
  • Admin
More
3 years 7 months ago #3608 by FlowHeater-Team
unnecessary zeros was created by FlowHeater-Team
Hello all,

I have the following situation: I have csv file  in excel  to import, I need to export as XML . I could not omit unnecessary zeros before -5 and separate 5 with a comma so that it is seen as a decimal number. And with the 10101 one has to look like 010101.

Can anyone help me at this point?

many thanks
[request received via mail]

File Attachment:

File Name: nullen_202...12-2.txt
File Size:0 KB

Best wishes
Robert Stark

Did this answer your question? We would be grateful if you provide a brief comment as feedback. It may also help others who may have encountered a similar problem.

Please Log in or Create an account to join the conversation.

  • FlowHeater-Team
  • avatar Topic Author
  • Offline
  • Admin
  • Admin
More
3 years 7 months ago - 6 months 2 weeks ago #3609 by FlowHeater-Team
Replied by FlowHeater-Team on topic unnecessary zeros
Hi,

You just need the String Append Heater . Here you have to configure a fixed length for your string, right alignment and fill shorter strings with the character “0”, that’s all.

Attached you´ll find a simple example.



File Attachment:

File Name: string-format.zip
File Size:7 KB

Best wishes
Robert Stark

Did this answer your question? We would be grateful if you provide a brief comment as feedback. It may also help others who may have encountered a similar problem.
Last edit: 6 months 2 weeks ago by FlowHeater-Team.

Please Log in or Create an account to join the conversation.

More
3 years 7 months ago #3610 by Sherzod Sultonov
Replied by Sherzod Sultonov on topic unnecessary zeros
thank you very much Herr Stark

Please Log in or Create an account to join the conversation.

Time to create page: 0.278 seconds
FlowHeater Logo

FlowHeater - The Data Specialist

Efficient data integration and transformation with FlowHeater – the perfect solution for a seamless transfer of your data.

Legal information

Support & Contact

Contact

Phone:
0951 / 9933 9792

eMail:
This email address is being protected from spambots. You need JavaScript enabled to view it.


Copyright © 2009-2024 by FlowHeater GmbH. All rights reserved.