Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM SQL » View Thread |
Messages 1 to 4 of 4 total |
How to Trim ' From Column |
Wed, Jun 7 2006 6:29 PM | Permanent Link |
"Gavin Horne" | Hi,
I have some imported data at a client site that has ended up with a leading quotemark ( ' ) on a number of columns. Is there anyway to trim it off? I've tried the TRIM function but being a quotemark it confuses the statement. tried TRIM ' FROM CustomerName TRIM ''' FROM CustomerName Any help would be appreciated. -- Gavin Horne www.hornesoftware.com.au |
Wed, Jun 7 2006 6:41 PM | Permanent Link |
Jeff Cook | "Gavin Horne" <gavin@remove.me.hornesoftware.com.au> wrote on Thu, 8 Jun 2006 07:56:39 +0930
>Hi, > >I have some imported data at a client site that has ended up with a leading >quotemark ( ' ) on a number of columns. Is there anyway to trim it off? >I've tried the TRIM function but being a quotemark it confuses the >statement. > >tried >TRIM ' FROM CustomerName >TRIM ''' FROM CustomerName > >Any help would be appreciated. > >-- >Gavin Horne >www.hornesoftware.com.au > > Gavin I've never used it and I'm probably on a different version of DBISAM but .... I'd expect you to need four quotes i.e. TRIM '''' FROM CustomerName HTH Jeff -- Jeff Cook Aspect Systems Ltd Phone: +64-9-424 5388 Skype: jeffcooknz www.aspect.co.nz |
Wed, Jun 7 2006 6:46 PM | Permanent Link |
Jeff Cook | Jeff Cook <jeffc@aspect.co.nz> wrote on Thu, 8 Jun 2006 10:39:14 +1200
>Gavin > > >I've never used it and I'm probably on a different version of DBISAM but .... > >I'd expect you to need four quotes > >i.e. TRIM '''' FROM CustomerName > And reading the v3 manual - I think some parenthesis would be needed too:- CustomerName = TRIM(LEADING '''' FROM CustomerName) Cheers Jeff -- Jeff Cook Aspect Systems Ltd Phone: +64-9-424 5388 Skype: jeffcooknz www.aspect.co.nz |
Wed, Jun 7 2006 7:46 PM | Permanent Link |
"Gavin Horne" | Hi Jeff,
Thanks for that, it does help if you RTFM, stupid question under pressure However, I've also discovered that most of the fields have a leading space before the quote as well so my statememt ended up TRIM(LEADING '''' FROM LTRIM(AddressLine1)) Cheers, Gavin Horne www.hornesoftware.com.au "Jeff Cook" <jeffc@aspect.co.nz> wrote in message news:9C899A0D-1393-4EB3-9C9A-D2B2240045D7@news.elevatesoft.com... > Jeff Cook <jeffc@aspect.co.nz> wrote on Thu, 8 Jun 2006 10:39:14 +1200 > >>Gavin >> >> >>I've never used it and I'm probably on a different version of DBISAM but >>.... >> >>I'd expect you to need four quotes >> >>i.e. TRIM '''' FROM CustomerName >> > > And reading the v3 manual - I think some parenthesis would be needed too:- > > CustomerName = TRIM(LEADING '''' FROM CustomerName) > > Cheers > > Jeff > -- > Jeff Cook > Aspect Systems Ltd > Phone: +64-9-424 5388 > Skype: jeffcooknz > www.aspect.co.nz > > > > |
This web page was last updated on Sunday, May 5, 2024 at 10:18 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |