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: lineend I 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 Bentley Sent: Thursday, March 01, 2012 2:27 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: lineend Dan, If you do not have many tables and there fields are TEXT or NOTE you might try UPDATE 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 McGrath Sent: Thursday, March 01, 2012 9:18 AM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: lineend The 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 McGrath Software Developer QMI Security Solutions 1661 Glenlake Ave Itasca IL 60143 630-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
