This Sent from my iPhone
> On Jun 5, 2021, at 11:13 AM, 'Karen Tellef' via RBASE-L > <[email protected]> wrote: > > > 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 > > > set var 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 > IF SQLCODE = 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. -- 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/5359FC81-EB66-4F58-85AA-A5DC346F9134%40ogdengroup.com.
