I was going to suggest some code I had written, but your original email sounded like these characters were only in null fields and that wasn't what I had encountered. During a build update, I had a note field show a physical character where there had previously been lineend characters. I ran the following code (just extracted the most important parts here) against the note fields that had the issue. Not sure if you can use something like this.
I first did an "unload schema for <any table>" at the R> prompt and did a copy/paste of the value that was set for the SET LINEEND line into my program code for the vText value setvar vtext text = 'þ' set var vcr text = (CHAR(013)+ CHAR(010)) DROP CURSOR c1 DECLARE c1 CURSOR FOR SELECT ordid, shoporder FROM orditems where custreq contains.vtext OPEN c1 WHILE 1 = 1 THEN FETCH c1 INTO vordid, vso IFSQLCODE = 100 THEN BREAK ENDIF UPDATE orditems SET custreq = (SRPL(custreq,.vtext, .vcr, 0)) WHERE ordid = .vordid ENDWHILE Karen -----Original Message----- From: Rich <[email protected]> To: [email protected] Sent: Fri, Jun 4, 2021 8:59 pm Subject: Re: [RBASE-L] - Funky character 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. -- 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/1352517502.2687581.1622905880908%40mail.yahoo.com.
