With the freeware Version up to 100.000 recordscan be processed!
FlowHeater - The Data Import / Export Specialist
DOWNLOADFreeware Version (10 MB)- No registration required -
 
Welcome, Guest
Username: Password: Remember me
Forgot your password? Forgot your username? Create an account
Support Forum
XML Adapter
unnecessary zeros
See also the existing examples of using the XML Adapter , which may answer your question: general XML processing
  • Page:
  • 1

TOPIC:

unnecessary zeros 10 months 6 days ago #3608

  • FlowHeater-Team
  • FlowHeater-Team's Avatar Topic Author
  • Offline
  • Posts: 390
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 or Create an account to join the conversation.

unnecessary zeros 10 months 6 days ago #3609

  • FlowHeater-Team
  • FlowHeater-Team's Avatar Topic Author
  • Offline
  • Posts: 390
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:

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

Last edit: by FlowHeater-Team.

unnecessary zeros 10 months 3 days ago #3610

thank you very much Herr Stark

Please Log in or Create an account to join the conversation.
  • Page:
  • 1
Support Forum
XML Adapter
unnecessary zeros
Time to create page: 0.105 seconds

other Languages

de

FlowHeater Home

de en

Imprint/Contact

Privacy Statement

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

Follow us on

twitter  facebook

YouTube

 de en