If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Translating or changing a ^ to a comma
I have a field that is imported from a text file. The data arrives with the
^ seperating the last from the first name. I would like to change the ^ to a comma. Can someone please assist? |
#2
|
|||
|
|||
Translating or changing a ^ to a comma
Hi.
I would like to change the ^ to a comma. Use an UPDATE query to change this in all the records. Make a backup of your table first, in case something goes wrong. Create a new query (select your table name in the Database Window, then select the Insert - Query menu, then the "OK" button, then select the View - SQL View menu). Paste the following into the SQL View pane: UPDATE tblNames SET FullName = REPLACE (FullName, "^", ",", 1); Change the table name, tblNames, to your table's name, and change the column name, FullName, to your column's name. Run the query. HTH. Gunny See http://www.QBuilt.com for all your database needs. See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials. http://www.Access.QBuilt.com/html/ex...ributors2.html for contact info. "hkhella" wrote: I have a field that is imported from a text file. The data arrives with the ^ seperating the last from the first name. I would like to change the ^ to a comma. Can someone please assist? |
#3
|
|||
|
|||
Translating or changing a ^ to a comma
I was going to tell the OP just use Find/Replace on the Edit menu, searching for
^ and replacing with ", " (comma, one space). However, your solution is I'm sure better, plus exposes the OP to an update query. On Sun, 17 Dec 2006 15:11:00 -0800, '69 Camaro AM wrote: Hi. I would like to change the ^ to a comma. Use an UPDATE query to change this in all the records. Make a backup of your table first, in case something goes wrong. Create a new query (select your table name in the Database Window, then select the Insert - Query menu, then the "OK" button, then select the View - SQL View menu). Paste the following into the SQL View pane: UPDATE tblNames SET FullName = REPLACE (FullName, "^", ",", 1); Change the table name, tblNames, to your table's name, and change the column name, FullName, to your column's name. Run the query. HTH. Gunny See http://www.QBuilt.com for all your database needs. See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials. http://www.Access.QBuilt.com/html/ex...ributors2.html for contact info. "hkhella" wrote: I have a field that is imported from a text file. The data arrives with the ^ seperating the last from the first name. I would like to change the ^ to a comma. Can someone please assist? |
Thread Tools | |
Display Modes | |
|
|