Re: [RBASE-L] - Picking and Renaming Windows Files
Sorry I took it as a file because of the name.
Sent from my iPhone
> On Aug 1, 2018, at 2:42 PM, Claudine Robbins wrote:
>
> I haven’t tried based on the input being in a variable and not a file.
>
> I’ll try and report back.
>
> Thanks Buddy!
>
> Sent from my iPhone
>
> On Aug 1, 2018, at 1:03 PM, Buddy Walker wrote:
>
> Claudine
> Since you have commas in the file I would think you have to load the table
> instead of insert.
>
> Buddy
>
>
> From: rbase-l@googlegroups.com On Behalf Of
> Claudine Robbins
> Sent: Wednesday, August 1, 2018 1:21 PM
> To: rbase-l@googlegroups.com
> Subject: [RBASE-L] - Picking and Renaming Windows Files
>
> Hi all,
>
> I’m trying to capture multiple file names to rename them. The following code
> gives me the error: “ERROR-Incorrect number of values for this table (118)”.
>
> It appears I may need quotes around each value. Any easy way to do this?
>
> TIA,
>
> Claudine
>
> PLUGINS LoadFileNamePlus vFileName +
> |INITIAL_DIR C:\iex_x\CHRISPREP +
> |TITLE 'Select file' +
> |FULLPATH ON +
> |NO_CHANGE_DIR ON +
> |FILTER PDF Files (*.PDF)#*.PDF +
> |HIDE_READ_ONLY ON +
> |MULTISELECT ON +
> |SHOW_HIDDEN OFF +
> |ENABLE_SIZING ON +
> |VIEW_MODE LIST
>
> SET VAR vfilename = ( '('+.vfilename+')' )
>
> SET ERROR MESSAGE 2058 OFF
> DROP TABLE `tFileName` NOCHECK
> SET ERROR MESSAGE 2058 ON
> CREATE TEMP TABLE `tFileName` (`FILEN` TEXT (40))
>
> R>INSERT INTO tfilename (FILEN) VALUES (FILEN) SELECT ALL FROM
> -ERROR- Incorrect number of values for this table ( 118)
>
> R>sho v vfilename
> (C:\IEX_X\CHRISPREP\ACME-54572
> 05-BU-0702181107AU.pdf,C:\IEX_
> X\CHRISPREP\ACME-5457205-07021
> 81107AU.pdf,C:\IEX_X\CHRISPREP
> \ACME-5457205-INV-0702181107AU
> .pdf)
> --
> 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 rbase-l+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.
> --
> 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 rbase-l+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.
> --
> 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 rbase-l+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.
--
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 rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
RE: [RBASE-L] - Picking and Renaming Windows Files
Actually, since I can capture each file name, there is no need to load a table,
LOL.
Claudine
From: karentellef via RBASE-L [mailto:rbase-l@googlegroups.com]
Sent: Wednesday, August 01, 2018 3:00 PM
To: rbase-l@googlegroups.com
Subject: Re: [RBASE-L] - Picking and Renaming Windows Files
Sweet!
Karen
-Original Message-
From: Claudine Robbins
To: rbase-l
Sent: Wed, Aug 1, 2018 2:45 pm
Subject: RE: [RBASE-L] - Picking and Renaming Windows Files
Like a charm.
Thank you Karen!
[cid:image001.png@01D429AB.23348D20]
From: karentellef via RBASE-L
[mailto:rbase-l@googlegroups.com<mailto:rbase-l@googlegroups.com?>]
Sent: Wednesday, August 01, 2018 2:12 PM
To: rbase-l@googlegroups.com<mailto:l...@googlegroups.com>
Subject: Re: [RBASE-L] - Picking and Renaming Windows Files
Ahh I think I see what you're trying to do. Because you have multiple
filenames I think you'd have to strip each one. I haven't tested this code,
just winging it, but something like this might work. This would load each
filename into the table. The only problem you might have is if the filenames
contain spaces.
set var vloop int = 1
while 1 = 1 then
set var vtext = (ssub(.vfilename,.vloop))
if vtext is null then
break
endif
insert into tfilename (filen) values (.vtext)
set var vloop = (.vloop + 1)
endwhile
Karen
-Original Message-
From: Claudine Robbins mailto:crobb...@iexgroup.com>>
To: rbase-l mailto:l...@googlegroups.com>>
Sent: Wed, Aug 1, 2018 2:04 pm
Subject: RE: [RBASE-L] - Picking and Renaming Windows Files
Karen,
I tried at least half a dozen combinations including:
R>INSERT INTO tfilename SELECT ALL FROM
-ERROR- Syntax error (2367)
And get syntax errors…
Claudine
From: karentellef via RBASE-L
[mailto:rbase-l@googlegroups.com<mailto:rbase-l@googlegroups.com?>]
Sent: Wednesday, August 01, 2018 1:10 PM
To: rbase-l@googlegroups.com<mailto:l...@googlegroups.com>
Subject: Re: [RBASE-L] - Picking and Renaming Windows Files
Claudine: This syntax doesn't look right. Either you would use VALUES or
SELECT, but not both
INSERT INTO tfilename (FILEN) VALUES (FILEN) SELECT ALL FROM
Karen
-Original Message-
From: Buddy Walker mailto:walker.bu...@comcast.net>>
To: rbase-l mailto:l...@googlegroups.com>>
Sent: Wed, Aug 1, 2018 1:03 pm
Subject: RE: [RBASE-L] - Picking and Renaming Windows Files
Claudine
Since you have commas in the file I would think you have to load the table
instead of insert.
Buddy
From: rbase-l@googlegroups.com<mailto:l...@googlegroups.com>
mailto:l...@googlegroups.com>> On Behalf Of Claudine
Robbins
Sent: Wednesday, August 1, 2018 1:21 PM
To: rbase-l@googlegroups.com<mailto:l...@googlegroups.com>
Subject: [RBASE-L] - Picking and Renaming Windows Files
Hi all,
I’m trying to capture multiple file names to rename them. The following code
gives me the error: “ERROR-Incorrect number of values for this table (118)”.
It appears I may need quotes around each value. Any easy way to do this?
TIA,
Claudine
PLUGINS LoadFileNamePlus vFileName +
|INITIAL_DIR C:\iex_x\CHRISPREP +
|TITLE 'Select file' +
|FULLPATH ON +
|NO_CHANGE_DIR ON +
|FILTER PDF Files (*.PDF)#*.PDF +
|HIDE_READ_ONLY ON +
|MULTISELECT ON +
|SHOW_HIDDEN OFF +
|ENABLE_SIZING ON +
|VIEW_MODE LIST
SET VAR vfilename = ( '('+.vfilename+')' )
SET ERROR MESSAGE 2058 OFF
DROP TABLE `tFileName` NOCHECK
SET ERROR MESSAGE 2058 ON
CREATE TEMP TABLE `tFileName` (`FILEN` TEXT (40))
R>INSERT INTO tfilename (FILEN) VALUES (FILEN) SELECT ALL FROM
-ERROR- Incorrect number of values for this table ( 118)
R>sho v vfilename
(C:\IEX_X\CHRISPREP\ACME-54572
05-BU-0702181107AU.pdf,C:\IEX_
X\CHRISPREP\ACME-5457205-07021
81107AU.pdf,C:\IEX_X\CHRISPREP
\ACME-5457205-INV-0702181107AU
.pdf)
--
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
rbase-<mailto:rbase-l+unsubscr...@googlegroups.com>l+unsubscr...@googlegroups.com<mailto:l+unsubscr...@googlegroups.com>.
For more options, visit https://groups.google.com/d/optout.
--
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
rbase-<mailto:rbase-l+unsubscr...@googlegroups.com>l+unsubscr...@googlegroups.com<mailto:l+unsubscr...@googlegroups.com>.
For more options, visit https://groups.google.com/d/optout.
--
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 f
Re: [RBASE-L] - Picking and Renaming Windows Files
Sweet!
Karen
-Original Message-
From: Claudine Robbins
To: rbase-l
Sent: Wed, Aug 1, 2018 2:45 pm
Subject: RE: [RBASE-L] - Picking and Renaming Windows Files
Like a charm.
Thank you Karen!
From: karentellef via RBASE-L [mailto:rbase-l@googlegroups.com]
Sent: Wednesday, August 01, 2018 2:12 PM
To: rbase-l@googlegroups.com
Subject: Re: [RBASE-L] - Picking and Renaming Windows Files
Ahh I think I see what you're trying to do. Because you have multiple
filenames I think you'd have to strip each one. I haven't tested this code,
just winging it, but something like this might work. This would load each
filename into the table. The only problem you might have is if the filenames
contain spaces.
set var vloop int = 1
while 1 = 1 then
set var vtext = (ssub(.vfilename,.vloop))
if vtext is null then
break
endif
insert into tfilename (filen) values (.vtext)
set var vloop = (.vloop + 1)
endwhile
Karen
-Original Message-
From: Claudine Robbins
To: rbase-l
Sent: Wed, Aug 1, 2018 2:04 pm
Subject: RE: [RBASE-L] - Picking and Renaming Windows Files
Karen,
I tried at least half a dozen combinations including:
R>INSERT INTO tfilename SELECT ALL FROM
-ERROR- Syntax error (2367)
And get syntax errors…
Claudine
From: karentellef via RBASE-L [mailto:rbase-l@googlegroups.com]
Sent: Wednesday, August 01, 2018 1:10 PM
To: rbase-l@googlegroups.com
Subject: Re: [RBASE-L] - Picking and Renaming Windows Files
Claudine: This syntax doesn't look right. Either you would use VALUES or
SELECT, but not both
INSERT INTO tfilename (FILEN) VALUES (FILEN) SELECT ALL FROM
Karen
-Original Message-
From: Buddy Walker
To: rbase-l
Sent: Wed, Aug 1, 2018 1:03 pm
Subject: RE: [RBASE-L] - Picking and Renaming Windows Files
Claudine
Since you have commas in the file I would think you have to load the table
instead of insert.
Buddy
From: rbase-l@googlegroups.com On Behalf Of Claudine
Robbins
Sent: Wednesday, August 1, 2018 1:21 PM
To: rbase-l@googlegroups.com
Subject: [RBASE-L] - Picking and Renaming Windows Files
Hi all,
I’m trying to capture multiple file names to rename them. The following code
gives me the error: “ERROR-Incorrect number of values for this table (118)”.
It appears I may need quotes around each value. Any easy way to do this?
TIA,
Claudine
PLUGINS LoadFileNamePlus vFileName +
|INITIAL_DIR C:\iex_x\CHRISPREP +
|TITLE 'Select file' +
|FULLPATH ON +
|NO_CHANGE_DIR ON +
|FILTER PDF Files (*.PDF)#*.PDF +
|HIDE_READ_ONLY ON +
|MULTISELECT ON +
|SHOW_HIDDEN OFF +
|ENABLE_SIZING ON +
|VIEW_MODE LIST
SET VAR vfilename = ( '('+.vfilename+')' )
SET ERROR MESSAGE 2058 OFF
DROP TABLE `tFileName` NOCHECK
SET ERROR MESSAGE 2058 ON
CREATE TEMP TABLE `tFileName` (`FILEN` TEXT (40))
R>INSERT INTO tfilename (FILEN) VALUES (FILEN) SELECT ALL FROM
-ERROR- Incorrect number of values for this table ( 118)
R>sho v vfilename
(C:\IEX_X\CHRISPREP\ACME-54572
05-BU-0702181107AU.pdf,C:\IEX_
X\CHRISPREP\ACME-5457205-07021
81107AU.pdf,C:\IEX_X\CHRISPREP
\ACME-5457205-INV-0702181107AU
.pdf)
--
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
torbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
--
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
torbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
--
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
torbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
--
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
torbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
--
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
RE: [RBASE-L] - Picking and Renaming Windows Files
Like a charm.
Thank you Karen!
[cid:image001.png@01D429A6.3A381190]
From: karentellef via RBASE-L [mailto:rbase-l@googlegroups.com]
Sent: Wednesday, August 01, 2018 2:12 PM
To: rbase-l@googlegroups.com
Subject: Re: [RBASE-L] - Picking and Renaming Windows Files
Ahh I think I see what you're trying to do. Because you have multiple
filenames I think you'd have to strip each one. I haven't tested this code,
just winging it, but something like this might work. This would load each
filename into the table. The only problem you might have is if the filenames
contain spaces.
set var vloop int = 1
while 1 = 1 then
set var vtext = (ssub(.vfilename,.vloop))
if vtext is null then
break
endif
insert into tfilename (filen) values (.vtext)
set var vloop = (.vloop + 1)
endwhile
Karen
-Original Message-
From: Claudine Robbins
To: rbase-l
Sent: Wed, Aug 1, 2018 2:04 pm
Subject: RE: [RBASE-L] - Picking and Renaming Windows Files
Karen,
I tried at least half a dozen combinations including:
R>INSERT INTO tfilename SELECT ALL FROM
-ERROR- Syntax error (2367)
And get syntax errors…
Claudine
From: karentellef via RBASE-L
[mailto:rbase-l@googlegroups.com<mailto:rbase-l@googlegroups.com?>]
Sent: Wednesday, August 01, 2018 1:10 PM
To: rbase-l@googlegroups.com<mailto:l...@googlegroups.com>
Subject: Re: [RBASE-L] - Picking and Renaming Windows Files
Claudine: This syntax doesn't look right. Either you would use VALUES or
SELECT, but not both
INSERT INTO tfilename (FILEN) VALUES (FILEN) SELECT ALL FROM
Karen
-Original Message-
From: Buddy Walker mailto:walker.bu...@comcast.net>>
To: rbase-l mailto:l...@googlegroups.com>>
Sent: Wed, Aug 1, 2018 1:03 pm
Subject: RE: [RBASE-L] - Picking and Renaming Windows Files
Claudine
Since you have commas in the file I would think you have to load the table
instead of insert.
Buddy
From: rbase-l@googlegroups.com<mailto:l...@googlegroups.com>
mailto:l...@googlegroups.com>> On Behalf Of Claudine
Robbins
Sent: Wednesday, August 1, 2018 1:21 PM
To: rbase-l@googlegroups.com<mailto:l...@googlegroups.com>
Subject: [RBASE-L] - Picking and Renaming Windows Files
Hi all,
I’m trying to capture multiple file names to rename them. The following code
gives me the error: “ERROR-Incorrect number of values for this table (118)”.
It appears I may need quotes around each value. Any easy way to do this?
TIA,
Claudine
PLUGINS LoadFileNamePlus vFileName +
|INITIAL_DIR C:\iex_x\CHRISPREP +
|TITLE 'Select file' +
|FULLPATH ON +
|NO_CHANGE_DIR ON +
|FILTER PDF Files (*.PDF)#*.PDF +
|HIDE_READ_ONLY ON +
|MULTISELECT ON +
|SHOW_HIDDEN OFF +
|ENABLE_SIZING ON +
|VIEW_MODE LIST
SET VAR vfilename = ( '('+.vfilename+')' )
SET ERROR MESSAGE 2058 OFF
DROP TABLE `tFileName` NOCHECK
SET ERROR MESSAGE 2058 ON
CREATE TEMP TABLE `tFileName` (`FILEN` TEXT (40))
R>INSERT INTO tfilename (FILEN) VALUES (FILEN) SELECT ALL FROM
-ERROR- Incorrect number of values for this table ( 118)
R>sho v vfilename
(C:\IEX_X\CHRISPREP\ACME-54572
05-BU-0702181107AU.pdf,C:\IEX_
X\CHRISPREP\ACME-5457205-07021
81107AU.pdf,C:\IEX_X\CHRISPREP
\ACME-5457205-INV-0702181107AU
.pdf)
--
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
rbase-<mailto:rbase-l+unsubscr...@googlegroups.com>l+unsubscr...@googlegroups.com<mailto:l+unsubscr...@googlegroups.com>.
For more options, visit https://groups.google.com/d/optout.
--
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
rbase-<mailto:rbase-l+unsubscr...@googlegroups.com>l+unsubscr...@googlegroups.com<mailto:l+unsubscr...@googlegroups.com>.
For more options, visit https://groups.google.com/d/optout.
--
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
rbase-l+unsubscr...@googlegroups.com<mailto:rbase-l+unsubscr...@googlegroups.com>.
For more options, visit https://groups.google.com/d/optout.
--
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
rbase-l+unsubscr...@googlegroups.com<mailto:rbase-l+unsubscr...@googlegroups.com>.
For more options, visit https://grou
RE: [RBASE-L] - Picking and Renaming Windows Files
Karen,
I was in the midst of confirming this approach, which indeed works fine.
Claudine
From: karentellef via RBASE-L [mailto:rbase-l@googlegroups.com]
Sent: Wednesday, August 01, 2018 2:12 PM
To: rbase-l@googlegroups.com
Subject: Re: [RBASE-L] - Picking and Renaming Windows Files
Ahh I think I see what you're trying to do. Because you have multiple
filenames I think you'd have to strip each one. I haven't tested this code,
just winging it, but something like this might work. This would load each
filename into the table. The only problem you might have is if the filenames
contain spaces.
set var vloop int = 1
while 1 = 1 then
set var vtext = (ssub(.vfilename,.vloop))
if vtext is null then
break
endif
insert into tfilename (filen) values (.vtext)
set var vloop = (.vloop + 1)
endwhile
Karen
-Original Message-
From: Claudine Robbins
To: rbase-l
Sent: Wed, Aug 1, 2018 2:04 pm
Subject: RE: [RBASE-L] - Picking and Renaming Windows Files
Karen,
I tried at least half a dozen combinations including:
R>INSERT INTO tfilename SELECT ALL FROM
-ERROR- Syntax error (2367)
And get syntax errors…
Claudine
From: karentellef via RBASE-L
[mailto:rbase-l@googlegroups.com<mailto:rbase-l@googlegroups.com?>]
Sent: Wednesday, August 01, 2018 1:10 PM
To: rbase-l@googlegroups.com<mailto:l...@googlegroups.com>
Subject: Re: [RBASE-L] - Picking and Renaming Windows Files
Claudine: This syntax doesn't look right. Either you would use VALUES or
SELECT, but not both
INSERT INTO tfilename (FILEN) VALUES (FILEN) SELECT ALL FROM
Karen
-Original Message-
From: Buddy Walker mailto:walker.bu...@comcast.net>>
To: rbase-l mailto:l...@googlegroups.com>>
Sent: Wed, Aug 1, 2018 1:03 pm
Subject: RE: [RBASE-L] - Picking and Renaming Windows Files
Claudine
Since you have commas in the file I would think you have to load the table
instead of insert.
Buddy
From: rbase-l@googlegroups.com<mailto:l...@googlegroups.com>
mailto:l...@googlegroups.com>> On Behalf Of Claudine
Robbins
Sent: Wednesday, August 1, 2018 1:21 PM
To: rbase-l@googlegroups.com<mailto:l...@googlegroups.com>
Subject: [RBASE-L] - Picking and Renaming Windows Files
Hi all,
I’m trying to capture multiple file names to rename them. The following code
gives me the error: “ERROR-Incorrect number of values for this table (118)”.
It appears I may need quotes around each value. Any easy way to do this?
TIA,
Claudine
PLUGINS LoadFileNamePlus vFileName +
|INITIAL_DIR C:\iex_x\CHRISPREP +
|TITLE 'Select file' +
|FULLPATH ON +
|NO_CHANGE_DIR ON +
|FILTER PDF Files (*.PDF)#*.PDF +
|HIDE_READ_ONLY ON +
|MULTISELECT ON +
|SHOW_HIDDEN OFF +
|ENABLE_SIZING ON +
|VIEW_MODE LIST
SET VAR vfilename = ( '('+.vfilename+')' )
SET ERROR MESSAGE 2058 OFF
DROP TABLE `tFileName` NOCHECK
SET ERROR MESSAGE 2058 ON
CREATE TEMP TABLE `tFileName` (`FILEN` TEXT (40))
R>INSERT INTO tfilename (FILEN) VALUES (FILEN) SELECT ALL FROM
-ERROR- Incorrect number of values for this table ( 118)
R>sho v vfilename
(C:\IEX_X\CHRISPREP\ACME-54572
05-BU-0702181107AU.pdf,C:\IEX_
X\CHRISPREP\ACME-5457205-07021
81107AU.pdf,C:\IEX_X\CHRISPREP
\ACME-5457205-INV-0702181107AU
.pdf)
--
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
rbase-<mailto:rbase-l+unsubscr...@googlegroups.com>l+unsubscr...@googlegroups.com<mailto:l+unsubscr...@googlegroups.com>.
For more options, visit https://groups.google.com/d/optout.
--
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
rbase-<mailto:rbase-l+unsubscr...@googlegroups.com>l+unsubscr...@googlegroups.com<mailto:l+unsubscr...@googlegroups.com>.
For more options, visit https://groups.google.com/d/optout.
--
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
rbase-l+unsubscr...@googlegroups.com<mailto:rbase-l+unsubscr...@googlegroups.com>.
For more options, visit https://groups.google.com/d/optout.
--
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
rbase-l+unsubscr...@googlegroups.com<mailto:rbase-l+unsubscr...@googlegroups.com>.
For more options, v
Re: [RBASE-L] - Picking and Renaming Windows Files
Ahh I think I see what you're trying to do. Because you have multiple
filenames I think you'd have to strip each one. I haven't tested this code,
just winging it, but something like this might work. This would load each
filename into the table. The only problem you might have is if the filenames
contain spaces.
set var vloop int = 1
while 1 = 1 then
set var vtext = (ssub(.vfilename,.vloop))
if vtext is null then
break
endif
insert into tfilename (filen) values (.vtext)
set var vloop = (.vloop + 1)
endwhile
Karen
-Original Message-
From: Claudine Robbins
To: rbase-l
Sent: Wed, Aug 1, 2018 2:04 pm
Subject: RE: [RBASE-L] - Picking and Renaming Windows Files
Karen,
I tried at least half a dozen combinations including:
R>INSERT INTO tfilename SELECT ALL FROM
-ERROR- Syntax error (2367)
And get syntax errors…
Claudine
From: karentellef via RBASE-L [mailto:rbase-l@googlegroups.com]
Sent: Wednesday, August 01, 2018 1:10 PM
To: rbase-l@googlegroups.com
Subject: Re: [RBASE-L] - Picking and Renaming Windows Files
Claudine: This syntax doesn't look right. Either you would use VALUES or
SELECT, but not both
INSERT INTO tfilename (FILEN) VALUES (FILEN) SELECT ALL FROM
Karen
-Original Message-
From: Buddy Walker
To: rbase-l
Sent: Wed, Aug 1, 2018 1:03 pm
Subject: RE: [RBASE-L] - Picking and Renaming Windows Files
Claudine
Since you have commas in the file I would think you have to load the table
instead of insert.
Buddy
From: rbase-l@googlegroups.com On Behalf Of Claudine
Robbins
Sent: Wednesday, August 1, 2018 1:21 PM
To: rbase-l@googlegroups.com
Subject: [RBASE-L] - Picking and Renaming Windows Files
Hi all,
I’m trying to capture multiple file names to rename them. The following code
gives me the error: “ERROR-Incorrect number of values for this table (118)”.
It appears I may need quotes around each value. Any easy way to do this?
TIA,
Claudine
PLUGINS LoadFileNamePlus vFileName +
|INITIAL_DIR C:\iex_x\CHRISPREP +
|TITLE 'Select file' +
|FULLPATH ON +
|NO_CHANGE_DIR ON +
|FILTER PDF Files (*.PDF)#*.PDF +
|HIDE_READ_ONLY ON +
|MULTISELECT ON +
|SHOW_HIDDEN OFF +
|ENABLE_SIZING ON +
|VIEW_MODE LIST
SET VAR vfilename = ( '('+.vfilename+')' )
SET ERROR MESSAGE 2058 OFF
DROP TABLE `tFileName` NOCHECK
SET ERROR MESSAGE 2058 ON
CREATE TEMP TABLE `tFileName` (`FILEN` TEXT (40))
R>INSERT INTO tfilename (FILEN) VALUES (FILEN) SELECT ALL FROM
-ERROR- Incorrect number of values for this table ( 118)
R>sho v vfilename
(C:\IEX_X\CHRISPREP\ACME-54572
05-BU-0702181107AU.pdf,C:\IEX_
X\CHRISPREP\ACME-5457205-07021
81107AU.pdf,C:\IEX_X\CHRISPREP
\ACME-5457205-INV-0702181107AU
.pdf)
--
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
torbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
--
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
torbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
--
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
torbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
--
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 rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
--
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 rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
RE: [RBASE-L] - Picking and Renaming Windows Files
Karen,
I tried at least half a dozen combinations including:
R>INSERT INTO tfilename SELECT ALL FROM
-ERROR- Syntax error (2367)
And get syntax errors…
Claudine
From: karentellef via RBASE-L [mailto:rbase-l@googlegroups.com]
Sent: Wednesday, August 01, 2018 1:10 PM
To: rbase-l@googlegroups.com
Subject: Re: [RBASE-L] - Picking and Renaming Windows Files
Claudine: This syntax doesn't look right. Either you would use VALUES or
SELECT, but not both
INSERT INTO tfilename (FILEN) VALUES (FILEN) SELECT ALL FROM
Karen
-Original Message-
From: Buddy Walker
To: rbase-l
Sent: Wed, Aug 1, 2018 1:03 pm
Subject: RE: [RBASE-L] - Picking and Renaming Windows Files
Claudine
Since you have commas in the file I would think you have to load the table
instead of insert.
Buddy
From: rbase-l@googlegroups.com<mailto:l...@googlegroups.com>
mailto:l...@googlegroups.com>> On Behalf Of Claudine
Robbins
Sent: Wednesday, August 1, 2018 1:21 PM
To: rbase-l@googlegroups.com<mailto:l...@googlegroups.com>
Subject: [RBASE-L] - Picking and Renaming Windows Files
Hi all,
I’m trying to capture multiple file names to rename them. The following code
gives me the error: “ERROR-Incorrect number of values for this table (118)”.
It appears I may need quotes around each value. Any easy way to do this?
TIA,
Claudine
PLUGINS LoadFileNamePlus vFileName +
|INITIAL_DIR C:\iex_x\CHRISPREP +
|TITLE 'Select file' +
|FULLPATH ON +
|NO_CHANGE_DIR ON +
|FILTER PDF Files (*.PDF)#*.PDF +
|HIDE_READ_ONLY ON +
|MULTISELECT ON +
|SHOW_HIDDEN OFF +
|ENABLE_SIZING ON +
|VIEW_MODE LIST
SET VAR vfilename = ( '('+.vfilename+')' )
SET ERROR MESSAGE 2058 OFF
DROP TABLE `tFileName` NOCHECK
SET ERROR MESSAGE 2058 ON
CREATE TEMP TABLE `tFileName` (`FILEN` TEXT (40))
R>INSERT INTO tfilename (FILEN) VALUES (FILEN) SELECT ALL FROM
-ERROR- Incorrect number of values for this table ( 118)
R>sho v vfilename
(C:\IEX_X\CHRISPREP\ACME-54572
05-BU-0702181107AU.pdf,C:\IEX_
X\CHRISPREP\ACME-5457205-07021
81107AU.pdf,C:\IEX_X\CHRISPREP
\ACME-5457205-INV-0702181107AU
.pdf)
--
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
rbase-l+unsubscr...@googlegroups.com<mailto:rbase-l+unsubscr...@googlegroups.com>.
For more options, visit https://groups.google.com/d/optout.
--
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
rbase-l+unsubscr...@googlegroups.com<mailto:rbase-l+unsubscr...@googlegroups.com>.
For more options, visit https://groups.google.com/d/optout.
--
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
rbase-l+unsubscr...@googlegroups.com<mailto:rbase-l+unsubscr...@googlegroups.com>.
For more options, visit https://groups.google.com/d/optout.
--
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 rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
RE: [RBASE-L] - Picking and Renaming Windows Files
Buddy,
As I suspected LOAD requires a file.
R>load tfilename from as CSV
-ERROR- File not found (2077)
End R:BASE Data Loading. 0 rows added to tfilename
Claudine
From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of
Buddy Walker
Sent: Wednesday, August 01, 2018 1:04 PM
To: rbase-l@googlegroups.com
Subject: RE: [RBASE-L] - Picking and Renaming Windows Files
Claudine
Since you have commas in the file I would think you have to load the table
instead of insert.
Buddy
From: rbase-l@googlegroups.com On Behalf Of Claudine
Robbins
Sent: Wednesday, August 1, 2018 1:21 PM
To: rbase-l@googlegroups.com
Subject: [RBASE-L] - Picking and Renaming Windows Files
Hi all,
I’m trying to capture multiple file names to rename them. The following code
gives me the error: “ERROR-Incorrect number of values for this table (118)”.
It appears I may need quotes around each value. Any easy way to do this?
TIA,
Claudine
PLUGINS LoadFileNamePlus vFileName +
|INITIAL_DIR C:\iex_x\CHRISPREP +
|TITLE 'Select file' +
|FULLPATH ON +
|NO_CHANGE_DIR ON +
|FILTER PDF Files (*.PDF)#*.PDF +
|HIDE_READ_ONLY ON +
|MULTISELECT ON +
|SHOW_HIDDEN OFF +
|ENABLE_SIZING ON +
|VIEW_MODE LIST
SET VAR vfilename = ( '('+.vfilename+')' )
SET ERROR MESSAGE 2058 OFF
DROP TABLE `tFileName` NOCHECK
SET ERROR MESSAGE 2058 ON
CREATE TEMP TABLE `tFileName` (`FILEN` TEXT (40))
R>INSERT INTO tfilename (FILEN) VALUES (FILEN) SELECT ALL FROM
-ERROR- Incorrect number of values for this table ( 118)
R>sho v vfilename
(C:\IEX_X\CHRISPREP\ACME-54572
05-BU-0702181107AU.pdf,C:\IEX_
X\CHRISPREP\ACME-5457205-07021
81107AU.pdf,C:\IEX_X\CHRISPREP
\ACME-5457205-INV-0702181107AU
.pdf)
--
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
rbase-l+unsubscr...@googlegroups.com<mailto:rbase-l+unsubscr...@googlegroups.com>.
For more options, visit https://groups.google.com/d/optout.
--
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
rbase-l+unsubscr...@googlegroups.com<mailto:rbase-l+unsubscr...@googlegroups.com>.
For more options, visit https://groups.google.com/d/optout.
--
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 rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
Re: [RBASE-L] - Picking and Renaming Windows Files
I haven’t tried based on the input being in a variable and not a file.
I’ll try and report back.
Thanks Buddy!
Sent from my iPhone
On Aug 1, 2018, at 1:03 PM, Buddy Walker
mailto:walker.bu...@comcast.net>> wrote:
Claudine
Since you have commas in the file I would think you have to load the table
instead of insert.
Buddy
From: rbase-l@googlegroups.com<mailto:rbase-l@googlegroups.com>
mailto:rbase-l@googlegroups.com>> On Behalf Of
Claudine Robbins
Sent: Wednesday, August 1, 2018 1:21 PM
To: rbase-l@googlegroups.com<mailto:rbase-l@googlegroups.com>
Subject: [RBASE-L] - Picking and Renaming Windows Files
Hi all,
I’m trying to capture multiple file names to rename them. The following code
gives me the error: “ERROR-Incorrect number of values for this table (118)”.
It appears I may need quotes around each value. Any easy way to do this?
TIA,
Claudine
PLUGINS LoadFileNamePlus vFileName +
|INITIAL_DIR C:\iex_x\CHRISPREP +
|TITLE 'Select file' +
|FULLPATH ON +
|NO_CHANGE_DIR ON +
|FILTER PDF Files (*.PDF)#*.PDF +
|HIDE_READ_ONLY ON +
|MULTISELECT ON +
|SHOW_HIDDEN OFF +
|ENABLE_SIZING ON +
|VIEW_MODE LIST
SET VAR vfilename = ( '('+.vfilename+')' )
SET ERROR MESSAGE 2058 OFF
DROP TABLE `tFileName` NOCHECK
SET ERROR MESSAGE 2058 ON
CREATE TEMP TABLE `tFileName` (`FILEN` TEXT (40))
R>INSERT INTO tfilename (FILEN) VALUES (FILEN) SELECT ALL FROM
-ERROR- Incorrect number of values for this table ( 118)
R>sho v vfilename
(C:\IEX_X\CHRISPREP\ACME-54572
05-BU-0702181107AU.pdf,C:\IEX_
X\CHRISPREP\ACME-5457205-07021
81107AU.pdf,C:\IEX_X\CHRISPREP
\ACME-5457205-INV-0702181107AU
.pdf)
--
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
rbase-l+unsubscr...@googlegroups.com<mailto:rbase-l+unsubscr...@googlegroups.com>.
For more options, visit https://groups.google.com/d/optout.
--
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
rbase-l+unsubscr...@googlegroups.com<mailto:rbase-l+unsubscr...@googlegroups.com>.
For more options, visit https://groups.google.com/d/optout.
--
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 rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
Re: [RBASE-L] - Picking and Renaming Windows Files
Claudine: This syntax doesn't look right. Either you would use VALUES or
SELECT, but not both
INSERT INTO tfilename (FILEN) VALUES (FILEN) SELECT ALL FROM
Karen
-Original Message-
From: Buddy Walker
To: rbase-l
Sent: Wed, Aug 1, 2018 1:03 pm
Subject: RE: [RBASE-L] - Picking and Renaming Windows Files
Claudine
Since you have commas in the file I would think you have to load the table
instead of insert.
Buddy
From: rbase-l@googlegroups.com On Behalf Of Claudine
Robbins
Sent: Wednesday, August 1, 2018 1:21 PM
To: rbase-l@googlegroups.com
Subject: [RBASE-L] - Picking and Renaming Windows Files
Hi all,
I’m trying to capture multiple file names to rename them. The following code
gives me the error: “ERROR-Incorrect number of values for this table (118)”.
It appears I may need quotes around each value. Any easy way to do this?
TIA,
Claudine
PLUGINS LoadFileNamePlus vFileName +
|INITIAL_DIR C:\iex_x\CHRISPREP +
|TITLE 'Select file' +
|FULLPATH ON +
|NO_CHANGE_DIR ON +
|FILTER PDF Files (*.PDF)#*.PDF +
|HIDE_READ_ONLY ON +
|MULTISELECT ON +
|SHOW_HIDDEN OFF +
|ENABLE_SIZING ON +
|VIEW_MODE LIST
SET VAR vfilename = ( '('+.vfilename+')' )
SET ERROR MESSAGE 2058 OFF
DROP TABLE `tFileName` NOCHECK
SET ERROR MESSAGE 2058 ON
CREATE TEMP TABLE `tFileName` (`FILEN` TEXT (40))
R>INSERT INTO tfilename (FILEN) VALUES (FILEN) SELECT ALL FROM
-ERROR- Incorrect number of values for this table ( 118)
R>sho v vfilename
(C:\IEX_X\CHRISPREP\ACME-54572
05-BU-0702181107AU.pdf,C:\IEX_
X\CHRISPREP\ACME-5457205-07021
81107AU.pdf,C:\IEX_X\CHRISPREP
\ACME-5457205-INV-0702181107AU
.pdf)
--
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 rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
--
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 rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
--
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 rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
RE: [RBASE-L] - Picking and Renaming Windows Files
Claudine
Since you have commas in the file I would think you have to load the table
instead of insert.
Buddy
From: rbase-l@googlegroups.com On Behalf Of Claudine
Robbins
Sent: Wednesday, August 1, 2018 1:21 PM
To: rbase-l@googlegroups.com
Subject: [RBASE-L] - Picking and Renaming Windows Files
Hi all,
I’m trying to capture multiple file names to rename them. The following code
gives me the error: “ERROR-Incorrect number of values for this table (118)”.
It appears I may need quotes around each value. Any easy way to do this?
TIA,
Claudine
PLUGINS LoadFileNamePlus vFileName +
|INITIAL_DIR C:\iex_x\CHRISPREP +
|TITLE 'Select file' +
|FULLPATH ON +
|NO_CHANGE_DIR ON +
|FILTER PDF Files (*.PDF)#*.PDF +
|HIDE_READ_ONLY ON +
|MULTISELECT ON +
|SHOW_HIDDEN OFF +
|ENABLE_SIZING ON +
|VIEW_MODE LIST
SET VAR vfilename = ( '('+.vfilename+')' )
SET ERROR MESSAGE 2058 OFF
DROP TABLE `tFileName` NOCHECK
SET ERROR MESSAGE 2058 ON
CREATE TEMP TABLE `tFileName` (`FILEN` TEXT (40))
R>INSERT INTO tfilename (FILEN) VALUES (FILEN) SELECT ALL FROM
-ERROR- Incorrect number of values for this table ( 118)
R>sho v vfilename
(C:\IEX_X\CHRISPREP\ACME-54572
05-BU-0702181107AU.pdf,C:\IEX_
X\CHRISPREP\ACME-5457205-07021
81107AU.pdf,C:\IEX_X\CHRISPREP
\ACME-5457205-INV-0702181107AU
.pdf)
--
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 rbase-l+unsubscr...@googlegroups.com
<mailto:rbase-l+unsubscr...@googlegroups.com> .
For more options, visit https://groups.google.com/d/optout.
--
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 rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
[RBASE-L] - Picking and Renaming Windows Files
Hi all,
I'm trying to capture multiple file names to rename them. The following code
gives me the error: "ERROR-Incorrect number of values for this table (118)".
It appears I may need quotes around each value. Any easy way to do this?
TIA,
Claudine
PLUGINS LoadFileNamePlus vFileName +
|INITIAL_DIR C:\iex_x\CHRISPREP +
|TITLE 'Select file' +
|FULLPATH ON +
|NO_CHANGE_DIR ON +
|FILTER PDF Files (*.PDF)#*.PDF +
|HIDE_READ_ONLY ON +
|MULTISELECT ON +
|SHOW_HIDDEN OFF +
|ENABLE_SIZING ON +
|VIEW_MODE LIST
SET VAR vfilename = ( '('+.vfilename+')' )
SET ERROR MESSAGE 2058 OFF
DROP TABLE `tFileName` NOCHECK
SET ERROR MESSAGE 2058 ON
CREATE TEMP TABLE `tFileName` (`FILEN` TEXT (40))
R>INSERT INTO tfilename (FILEN) VALUES (FILEN) SELECT ALL FROM
-ERROR- Incorrect number of values for this table ( 118)
R>sho v vfilename
(C:\IEX_X\CHRISPREP\ACME-54572
05-BU-0702181107AU.pdf,C:\IEX_
X\CHRISPREP\ACME-5457205-07021
81107AU.pdf,C:\IEX_X\CHRISPREP
\ACME-5457205-INV-0702181107AU
.pdf)
--
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 rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
