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

for reason lots of null on csv output

More
5 months 3 weeks ago #3805 by brian clark
for reason lots of null on csv output was created by brian clark
Hi Robert
No idea why there are so many nul in this csv output file.
4.4.1 beta 3 version.
I have tried everything and its still there
100k rows
35304 = correct amount of html files, but seems 3k are just filled with nul. which makes no sense. 
turned off row limit,
extended size of row limit to 25 million as some html files are 21mb in size.
reduced and removed a lot of html characters non ascii including the comma so the csv actually works and white spaces to save some space to import into postgresql
but for some odd reason 3k lines are nulled.

 

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

More
5 months 3 weeks ago #3806 by brian clark
Replied by brian clark on topic for reason lots of null on csv output
text file 2 added
Attachments:

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

More
5 months 3 weeks ago #3807 by FlowHeater-Team
Replied by FlowHeater-Team on topic for reason lots of null on csv output
Hi Brian,

I guess your HTML files are contains these HEX 0 values! Please find attached your modified definition. I´ve added a .NET Script Heater to remove these unwanted values in your CSV output.
Code:
public object DoWork() {     // get the first input value     string sIN = (string)InValues[0].GetString();     // remove hex0 (0x00) values from string     return sIN.Replace("\0", ""); }

 

File Attachment:

File Name: remove-hex...iles.zip
File Size:468 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.

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