[RBASE-L] - RE: Trailing commas

[anne]

Thank You Jason,

Was able to clean them all out!

Anne

-------- Original Message --------
Subject: [RBASE-L] - RE: Trailing commas
From: "Kramer, Jason J" <jjkra...@udel.edu>
Date: Thu, February 05, 2015 3:54 pm
To: rbase-l@rbase.com (RBASE-L Mailing List)

                This may not be the most elegant, but it will work.  If you have a particularly large dataset, it may take a while.  This will remove ANY trailing comma, so if you have some that you want to keep, this will not work.  Also, this will remove only one trailing comma per entry, so if you have an entry like MyData,,. Then the result will be MyData, not MyData.

 

UPDATE MyTable Set MyCol=IFEQ((SGET(MyCol,1,SLEN(MyCol))),',',(SGET(MyCol,(SLEN(MyCol)-1),1)),MyCol)

 

                                                                Jason

 

Jason Kramer

University Archives and Records Management

002 Pearson Hall

(302) 831 - 3127 (voice)

(302) 831 - 6903 (fax)

 

From: rbase-l@rbase.com [mailto:rbase-l@rbase.com] On Behalf Of a...@redcaptransport.net
Sent: Thursday, February 05, 2015 3:25 PM
To: RBASE-L Mailing List
Subject: [RBASE-L] - Trailing commas

 

Hi all

 

Imported a file and in a couple of the columns a trailing comma has appeared

with the data. 

 

What would be the most elegant to remove these?

 

The SGET command is what I am finding. 

Any advise would be appreciated.

 

 

Thanks

Anne