Thks that makes sense. I will investigate tomorrow Sent from my iPhone
> On Jun 4, 2021, at 6:24 PM, nicholas avery <[email protected]> wrote: > > > > > 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]>, 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. >>> -- >>> 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. >> -- >> 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. > > > -- > 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. -- 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/5317BE44-70A3-4FB8-A1AC-6F835F651D04%40ogdengroup.com.
