I sent this response to Bruce by mistake - sorry! - then found out I was sending from the wrong email. Oh, well.
I've seen this happen in output from fields which look null but are in fact populated with a keystroke which is not a valid char. I learned something new since the email I sent to Bruce: I believed the ÿÿÿ corresponded to a carriage return but a quick search found a Reddit mention that it corresponds to the color white in hex. Either way, it's garbage so I'd locate the fields in question and UPDATE them to NULL then try to export as CSV again. If you convert the hex code for the color white (FFFFFF) to ASCII characters, you get: ÿÿÿ Three ÿ's, man?!? Or did he mean three wise men? HTH Nicky On 6/3/2021 7:58 PM, Bruce Chitiea wrote: I’m away from my R:BASE, so this is bare-bones. Have you tried this: OUTPUT funkyDatabase.rmd UNLOAD ALL OUTPUT SCREEN ... then go funk-hunting with the Editor? After a full backup, an UNLOAD /RELOAD cycle might solve the issue, or at least yield up useful clues. Bruce Chitiea SafeSectors, Inc Btw: which R:BASE version? On Jun 3, 2021, 19:30 -0700, Rich <[email protected]> <[email protected]>, wrote: Did anyone get this? Sent from my iPhone On Jun 3, 2021, at 12:53 PM, [email protected] wrote: I have a program that creates a CSV file of names. All of a sudden, a couple of fields that are null contain this character ÿÿÿ. I have set nulls to ‘ ‘. It is not all the fields just 2. The configuration setting has Blank box yellowed and will not let me change it. The CFG file has Blank = ‘ ‘. Any ideas? Rich Jasinski -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/015e01d75898%24f468ef70%24dd3ace50%24%40ogdengroup.com <https://groups.google.com/d/msgid/rbase-l/015e01d75898%24f468ef70%24dd3ace50%24%40ogdengroup.com?utm_medium=email&utm_source=footer> . -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/A613E023-6F66-4645-9834-E8C67175F7C5%40ogdengroup.com <https://groups.google.com/d/msgid/rbase-l/A613E023-6F66-4645-9834-E8C67175F7C5%40ogdengroup.com?utm_medium=email&utm_source=footer> . -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/876c608c-8768-472c-b121-6b87bbe7f816%40Spark <https://groups.google.com/d/msgid/rbase-l/876c608c-8768-472c-b121-6b87bbe7f816%40Spark?utm_medium=email&utm_source=footer> . -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/CAE0t16Yqx3s7d8OvcMmx2pOFK2%2B_hAi1Qm6chaAc-tQsQ7tFSw%40mail.gmail.com.
