You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hop.apache.org by "bmoAtolcd (via GitHub)" <gi...@apache.org> on 2025/09/23 07:18:12 UTC
[I] [Bug]: Text file input not keep null string (hop)
bmoAtolcd opened a new issue, #5725:
URL: https://github.com/apache/hop/issues/5725
### Apache Hop version?
2.14.0
### Java version?
OpenJDK 64-Bit Server VM Temurin-21.0.6+7
### Operating system
macOS
### What happened?
When variable HOP_EMPTY_STRING_DIFFERS_FROM_NULL is set to Y, Text file input should keep difference between null and empty string.
Enclosure: "
separator: ;
id;emtpy_collumn;null_collumn;label
1;"";;"a label"
emtpy_collumn and null_collumn are set to empty string, null_collum should be set to <null>
[test.zip](https://github.com/user-attachments/files/22488274/test.zip)
### Issue Priority
Priority: 2
### Issue Component
Component: Transforms
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: issues-unsubscribe@hop.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] [Bug]: Text file input not keep null string (hop)
Posted by "hansva (via GitHub)" <gi...@apache.org>.
hansva closed issue #5725: [Bug]: Text file input not keep null string
URL: https://github.com/apache/hop/issues/5725
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: issues-unsubscribe@hop.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] [Bug]: Text file input not keep null string (hop)
Posted by "hansva (via GitHub)" <gi...@apache.org>.
hansva commented on issue #5725:
URL: https://github.com/apache/hop/issues/5725#issuecomment-3370722597
I am not sure about this one, as there is not really a standard for text files. Enclosure is only required when using the delimiter inside the text field. It's not really used to differentiate null and empty strings. The best way to handle this is to have the source write a specific value for null fields (eg. <NULL>) and then you can use the "Null if" option in the fields section.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: issues-unsubscribe@hop.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] [Bug]: Text file input not keep null string (hop)
Posted by "hansva (via GitHub)" <gi...@apache.org>.
hansva commented on issue #5725:
URL: https://github.com/apache/hop/issues/5725#issuecomment-5215091425
I added a new option in the content tab to treat values that are not enclosed as null values.
This way we keep backwards compatibility but provide the option
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: issues-unsubscribe@hop.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] [Bug]: Text file input not keep null string (hop)
Posted by "hansva (via GitHub)" <gi...@apache.org>.
hansva commented on issue #5725:
URL: https://github.com/apache/hop/issues/5725#issuecomment-5214754788
.take-issue
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: issues-unsubscribe@hop.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org