- Posts: 63
for reason lots of null on csv output
- brian clark
- Topic Author
- Offline
- User
Less
More
6 months 3 weeks ago #3805
by brian clark
for reason lots of null on csv output - Post(3805) 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
6 months 3 weeks ago #3806
by brian clark
Replied by brian clark on topic for reason lots of null on csv output - Post(3806)
text file 2 added
Attachments:
Please Log in or Create an account to join the conversation.
- FlowHeater-Team
- Offline
- Admin
6 months 3 weeks ago #3807
by FlowHeater-Team
Best wishes
Robert Stark
Replied by FlowHeater-Team on topic for reason lots of null on csv output - Post(3807)
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
Please Log in or Create an account to join the conversation.
Time to create page: 0.271 seconds