Got it. Thanks.
-----Original Message----- From: "Paul Buckley" <[email protected]> To: [email protected] (RBASE-L Mailing List) Date: Mon, 5 Mar 2012 13:36:58 -0500 Subject: [RBASE-L] - RE: - off topic Jan, If you Google “change date and time on a file”, you’ll see dozens. I’ve used several of these, they’re free and all work about the same. Paul From: [email protected] [mailto:[email protected]] On Behalf Of jan johansen Sent: Monday, March 05, 2012 1:22 PM To: RBASE-L Mailing List Subject: [RBASE-L] - off topic I want to make a number of files (pdf,doc, etc.) have the same date time information.Does any one know how to do that? -----Original Message----- From: "Dan Goldberg" <[email protected]> To: [email protected] (RBASE-L Mailing List) Date: Mon, 5 Mar 2012 10:14:36 -0800 Subject: [RBASE-L] - RE: lineendI have successfully changed my lineend to the same on all my databases over the weekend. You command helped make it painless. Dan Goldberg From: James BentleySent: Thursday, March 01, 2012 2:27 PMTo: RBASE-L Mailing ListSubject: [RBASE-L] - RE: lineendDan, If you do not have many tables and there fields are TEXT or NOTE you might tryUPDATE TABLE tablename SET colname=(SRPL(colname,'^',(CHAR(254)),0)) WHERE colname CONTAINS '^'appropriate cautions about backing up database before trying substitute for '^' and CHAR(254) where appropriate in above command Jim Bentley American Celiac Society [email protected] tel: 1-504-737-3293 From: Dan Goldberg <[email protected]> To: RBASE-L Mailing List <[email protected]> Sent: Thursday, March 1, 2012 3:37 PM Subject: [RBASE-L] - RE: lineend I think I will change all my databases to the funny looking b. Now I have to figure out the best way to do this. I will have to change the lineend but I have to change the data somehow. I am thinking I will have to do an unload, search/replace. Dan From: Dennis McGrathSent: Thursday, March 01, 2012 9:18 AMTo: RBASE-L Mailing ListSubject: [RBASE-L] - RE: lineendThe funny looking b is ascii character 254 The other one is the caret (above 6 on the US keyboard.) 254 is preferable because it is far less likely to occur in text. FYI it looks like a little filled in square in DOS and the Windows R> screen. Dennis McGrathSoftware DeveloperQMI Security Solutions1661 Glenlake AveItasca IL 60143630-980-8461 [email protected] From: [email protected] [mailto:[email protected]] On Behalf Of Dan Goldberg Sent: Thursday, March 01, 2012 11:07 AM To: RBASE-L Mailing List Subject: [RBASE-L] - lineend What is the default character for lineend? I have seen both the weird looking b þ and ^ Dan Goldberg
