473,324 Members | 2,257 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,324 software developers and data experts.

Removing semicolon data containing in 3 columns arrange in 3 row data

I had 2 tables 1st ABC table i had 5 columns,2nd table by name EFG had 5 columns.
data is
1st table ABC
a b c d e
- - - - -
1;2;2;3 5;6 ag lm12 string
1,2,5 8;6 ef lki23 aaa

update in table EFG by comparing in above table
a b c d e
- - - - -
1 6 ef update update
3 8 ag " "
Jul 30 '15 #1
0 2246

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

Similar topics

6
by: Jennifer Smith | last post by:
I want to be able to display my recordset as follows: a e b f c g d h Instead of : a b c d
1
by: ccr | last post by:
Reposted with a longer line length. Apologies if I did not cancel the 1st attempt before you got it. If necessary, please view in a text editor so the columnar text lines up. I used Terminal...
11
by: Hi5 | last post by:
Hi, I am new to access I usedto work in Oracle and Mysql. I am after a way that enables me to populate a database I designed in access with lots of data which can be sorted in excel sheets, ...
5
by: Kutty Banerjee | last post by:
hi , i ve int (*Data); int A={1,2,3,4}; Data=&A; //Question here, how d i dynamically allocate space for Data using calloc? printf("%d\n",*Data) ; //gives 1 //But printf("%d\n",*Data)...
1
by: Jimbo | last post by:
Hi, I'm working on some basic analysis stuff and want to (ultimately) display my data on a chart by a month breakdown. To get each months data I need to run a separate query on the db, but I...
4
by: authorking | last post by:
I use the following code to insert a data record in to a datatable of an access database.But every time I execute the command, there will rise an exception and the insert operation can't be...
3
by: vvenk | last post by:
Hello: I created a datatable with two columns: ' Add three column objects to the table. idColumn = New DataColumn() idColumn.DataType = System.Type.GetType("System.String")...
0
by: dustonheaven | last post by:
I need to calculate running balance on data containing Null, which is sorted by few columns. As example below, Clr is sorted by Null Desc, then by date, then just by ID. So far, I just come out...
1
by: algoquant | last post by:
I have a csv file with data 51,000 x 3. (row x column) I'd like to read data from the csv, perform some functions and then have the output go to another csv. Can anyone recommend code for...
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...
1
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: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
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
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.