"\n" is removed from strings when using JSONGetElements.
Native JSON functions have some interesting behavior with certain escaped characters.
From the issue reports I have submitted on this type of thing in the past FMI seems to lean on this being expected behavior. Loss of data is expected? I guess that is the way it is.
Well I certainly wasn't expecting it! Odd, but oh well.
I did some quick testing, and it unfortunately looks like it's even a bit more complicated/mysterious than this. If there are other characters than Char ( 10 ) and Char ( 13 ) immediately before or after a Char ( 10 ), the Char ( 10 ) doesn't disappear but is returned as a \r.
Yes! Thank You for adding that. It’s one thing if it consistently removed them, but arbitrarily replacing them is another thing.
Thank you for your posts.
I have sent all information to our Development and Testing departments for review. When I receive any feedback, I will let you know.
Thanks, JSON is my favorite fm16 feature. Just want it to be as good as possible.
Development has said that whenever FileMaker is manipulating text paragraph terminators, they get changed to the carriage return character (¶). The JSON functions do not change this; it is FileMaker.
Retrieving data ...