- Posts: 63
for reason lots of null on csv output
- brian clark
- Topic Author
- Offline
- User
Less
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.
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.
Attachments:
Please Log in or Create an account to join the conversation.
- brian clark
- Topic Author
- Offline
- User
Less
More
- Posts: 63
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.
- FlowHeater-Team
- Offline
- Admin
5 months 3 weeks ago #3807
by FlowHeater-Team
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.
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.
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", "");
}
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