473,326 Members | 2,805 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

Replace certain portions of data tied to an ID.

2
Hi

I would like to update all the data in a column base on an ID. There are phone numbers in the data which is tied to the ID also. Kindly advise!

msg -------------------------------------------------------- ID
This is a test msg! Pls call 12345 -------------- 2233
This is a test msg! Pls call 23455 -------------- 4454
........
....

change to

msg ------------------------------------------------ ID
This is a test! Pls call 12345 ------------- 2233
This is a test! Pls call 23455 ------------- 4454
........
....
Jan 19 '07 #1
2 1070
Hi

I would like to update all the data in a column base on an ID. There are phone numbers in the data which is tied to the ID also. Kindly advise!

msg -------------------------------------------------------- ID
This is a test msg! Pls call 12345 -------------- 2233
This is a test msg! Pls call 23455 -------------- 4454
........
....

change to

msg ------------------------------------------------ ID
This is a test! Pls call 12345 ------------- 2233
This is a test! Pls call 23455 ------------- 4454
........
....
I think it will solve your problem
update table name set remk=substr(remk,1,instr(remk,'!')-1)||substr(remk,instr(remk,'!')+1,length(remk))
Jan 19 '07 #2
SL500
2
Kinda lost in figuring out how to tie each record to it's ID in the update statement. Seems like there is no such need, haha. Thanks alot :)
Jan 19 '07 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

2
by: Thomas Philips | last post by:
Using glob(), I obtain a list of filenames with some characters in upper case, others in lower case. I want to rename the files by replacing one substring in each filename with another, but with...
1
by: Jeffrey | last post by:
I would appreciate suggestions for a general strategy I could use to update a bunch of HTML files. Specifically I need to replace sevaral instances of one string with another string in each of a...
4
by: Neo Geshel | last post by:
Greetings I am using VB in my ASP.NET project that uses an admin web site to populate a database that provides content for a front end web site. I am looking for a way to use replace() to...
4
by: JackRazz | last post by:
Could someone give me a very simple regular expression for Visual Studio's search/replace using backreferences saving portions of the match as \1 or $1 or whatever. I want to use something I can...
1
by: Karen | last post by:
I am very new to MySQL- I currently have an VBA module using a VBSCript that will find different aspects of a text string that are a unique text string and turn it into a not so unique text string....
1
by: Harry.PharmTouch | last post by:
My company is seeking a software solution for the following scenario. Please let me know if you have any suggestions. We are a small consulting company that services nursing homes. We need to...
10
by: Barry L. Camp | last post by:
Hi all... hope someone can help out. Not a unique situation, but my search for a solution has not yielded what I need yet. I'm trying to come up with a regular expression for a...
6
by: =?Utf-8?B?R2Vvcmdl?= | last post by:
Hello, I have some XML that is returned to my application from another vendor that I cannot change before it gets to me. I can only alter it after it gets to my application. That being said, I...
24
by: MNNovice | last post by:
I am working on a DB to record expenses related to various grants. To record Payroll expenses I created tblPayroll with these fields: PayrollID – auto / PK ECHOID – Number FK (tied to tblECHO)...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.