Is there any way to prevent or detect char(0) from texts?
In some occasions, specially when copy-pasting, we end up having some text fields with a character 0 (nul) at the end of a string.
It doesn't show in any way when you display the data, but you do detect it when you export it.
We've tried to (at least) detect it by using the "Position" function.
However Position(text_field, char(0), 1, 1) won't find this char (it does return 0, even if the character is there).
I guess this is some kind of bug from FileMaker, but I'd like to know if anyone has found a way to circumvent it...
More info and a database sample at: https://community.claris.com/en/s/question/0D53w00005wrUMMCA2/character-0-0x0-in-text-fields
Unfortunately, the result of Char(0) is an empty string, not the expected control character.
You can generate the null character in a number of ways:
HexDecode ( "00" )Base64Decode ( "AA==" )ExecuteSQL ( "SELECT DISTINCT CHR(0) FROM SomeTable" ; "" ; "" )
or paste it into a global field and get it from there.
Once you have the character, it's easy to detect it or just substitute it out.
You may want to bypass the entire issue by allowing only printable characters - see, for example: https://www.briandunning.com/cf/1291
- How can I find the index of a character in a string in Rust?
- How do I convert a Char to Int?
- How can I determine if a string contain all characters in character mask as a continuous substring?
- Character code of unknown character-character, e.g. square or question mark romb
- First unique character in a string using LinkedHashMap
- Removing NA_character_
- SAS Proc transpose wide to long multiple variables
- Is there a Unicode character for plus over minus? (+/-)
- Swift How to get integer from string and convert it into integer
- Trying to capitalize the first character in array of strings, why this is not working?
- How to count grapheme clusters or "perceived" emoji characters in Java
- Error "Source character set not supported by client" when field set to uft8mb4_general_ci
- Detect word in character variable text string and create variable based upon presence of that word SAS
- What method in the String class returns only the first N characters?
- Find out if Character in String is emoji?
- How to remove all emojis from specific table in mysql?
- What is the maximum number of bytes for a UTF-8 encoded character?
- Multi-character character constant [-Wmultichar] Error in C
- Get nth character of a string in Swift
- How can I find the number of unique characters in a string?
- How can I escape square brackets in a LIKE clause?
- Is UTF-8 an encoding or a character set?
- Check if column contains (/,-,_, *or~) and split in another column - Pandas
- The Longest Character In UTF-8
- Does Java define constants for any characters such as SPACE?
- "incompatible pointer type" compiling in C
- how to add CharacterEllipsis at the beginning of the textblock in wpf?
- getting last character from a string that may or may not be unicode
- How to remove certain characters from a string in C++?
- Escaping Shebang in grep