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.
Up to 100,000 records can be processed with the freeware version!
Flowheater Chart

unnecessary zeros

  • FlowHeater-Team
  • avatar Topic Author
  • Offline
  • Admin
  • Admin
More
3 years 9 months ago #3608 by FlowHeater-Team
unnecessary zeros - Post(3608) 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

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

  • FlowHeater-Team
  • avatar Topic Author
  • Offline
  • Admin
  • Admin
More
3 years 9 months ago - 8 months 4 days ago #3609 by FlowHeater-Team
Replied by FlowHeater-Team on topic unnecessary zeros - Post(3609)
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
Last edit: 8 months 4 days ago by FlowHeater-Team.

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

More
3 years 9 months ago #3610 by Sherzod Sultonov
Replied by Sherzod Sultonov on topic unnecessary zeros - Post(3610)
thank you very much Herr Stark

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

Time to create page: 0.268 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.