Remove a comma programmatically

#1

I have 2 fields of names that can't have commas. Is there a way I can
programmatically "find and replace"?

Thanks,
Laura

#2

I have to take a text file with about 600 records in it, import it,
total it up, store the totals, and export it in a specific delimited
format for another company. The file coming in might have commas in
the name that I need to remove. Is there a way I can do it in VB?
Can I use the code below and cycle through the records?

On Apr 24, 2:44*pm, fredg <fgutk... (AT) example (DOT) invalid> wrote:

Quote:

On Fri, 24 Apr 2009 12:15:45 -0700 (PDT), musicloverlch wrote:
I have 2 fields of names that can't have commas. Is there a way I can
programmatically "find and replace"?

Thanks,
Laura

Replace with what?
When? During entry?
Code the form control's AfterUdate event:
Me![ControlName] = Replace([ControlName],",","")

The above will just remove commas.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

#3

Perfect! You have saved my life. Thanks!

On Apr 24, 3:30*pm, fredg <fgutk... (AT) example (DOT) invalid> wrote:

Quote:

On Fri, 24 Apr 2009 13:20:54 -0700 (PDT), musicloverlch wrote:
I have to take a text file with about 600 records in it, import it,
total it up, store the totals, and export it in a specific delimited
format for another company. The file coming in might have commas in
the name that I need to remove. *Is there a way I can do it in VB?
Can I use the code below and cycle through the records?

On Apr 24, 2:44*pm, fredg <fgutk... (AT) example (DOT) invalid> wrote:
On Fri, 24 Apr 2009 12:15:45 -0700 (PDT), musicloverlch wrote:
I have 2 fields of names that can't have commas. Is there a way I can
programmatically "find and replace"?

Thanks,
Laura

Replace with what?
When? During entry?
Code the form control's AfterUdate event:
Me![ControlName] = Replace([ControlName],",","")

The above will just remove commas.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

After you import the names you can run an Update query.
Here is the query SQL. Change the table and field names to whatever
yours are. Make a backup of the table first.

Update YourTable Set YourTable.[FieldName] =
Replace([FieldName],",","")

Smith, John will become Smith John.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail- Hide quoted text -

- Show quoted text -

#4

musicloverlch wrote:

Quote:

I have 2 fields of names that can't have commas. Is there a way I can
programmatically "find and replace"?

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

*************************** BACK UP BEFORE TRYING THIS **************

UPDATE table_name
SET column_name = REPLACE(column_name, ",","")
WHERE column_name LIKE "*,*"

If you're using ANSI-92 SQL mode change the LIKE to "%,%".

HTH,
--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)
** Respond only to this newsgroup. I DO NOT respond to emails **

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBSfIl7YechKqOuFEgEQKLtACgvVKZ0HPFDYh/LplupIFZ1TRjfxUAn1jw
G8RhUEvM7Mz02ajX4FA6oPFW
=IiEG
-----END PGP SIGNATURE-----

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Remove a comma programmatically

comp.databases.ms-access comp.databases.ms-access

Remove a comma programmatically - 04-24-2009 , 02:15 PM

Re: Remove a comma programmatically - 04-24-2009 , 03:20 PM

Re: Remove a comma programmatically - 04-24-2009 , 03:44 PM

Re: Remove a comma programmatically - 04-24-2009 , 03:49 PM