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 Download

unnecessary zeros

  • FlowHeater-Team
  • Topic Author
  • Offline
  • Admin
  • Admin
More
3 years 1 month 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.
Attachments:

Please Log in to join the conversation.

  • FlowHeater-Team
  • Topic Author
  • Offline
  • Admin
  • Admin
More
3 years 1 month ago - 1 day 16 hours 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.
Attachments:
Last edit: 1 day 16 hours ago by FlowHeater-Team.

Please Log in to join the conversation.

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

Please Log in to join the conversation.

Time to create page: 0.284 seconds

FlowHeater - The Data Specialist

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

Rechtliches

Support & Contact

Kontaktinformation

Telefon:0951 / 99339792 E-Mail:This email address is being protected from spambots. You need JavaScript enabled to view it.

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