moving partial data on same table

[Marv916]

Hello,

I am having an issue with a current project which I thought would be a pretty easy process.

This is my issue. I have a "glob" of data in a column that I need to copy to a different column within the same table.

For example: I have a name, address and city in the same "glob" in a column. Can I write a query that would take the name, put it in the name column, address in the address column, etc.

If I need to give a better explanation, let me know. Thank you in advance.

 

[pbaldy]

It's certainly possible, but how depends on the data. Does something separate the data you want to break apart?

 

[MarkK]

When you try this, where do you get stuck? Also, is this a one-off data clean-up job, or are you designing a process that you will need to run repeatedly over time? I would approach those two problems very differently.
Cheers,

 

[Marv916]

Thank you for the quick replies.

To describe the data: The field the data would come from is a "glob" form in a sense. There is a bunch of data that has titles assigned to them but are all in the same field. Almost like a space delimited or comma delimited setup.

I could use the same "anchor" points if needed for example the name is between the same to "title" points i.e. N01: Name A01: address etc.
I thought of doing an InStr function to find the text and then define the parameters to copy once the "anchor" point is found to the appropriate column.

This is a one off process for this project until I can fix the application. Seems "PutScreen" stopped functioning when I went from VS2010 to VS2012.

 

[pbaldy]

I might help to see samples of the data, with no personal info of course. The Split() function might come in handy, as well as the InStr() you mentioned, Mid() and various string functions.

 

[pbaldy]

Looks like you solved the issue? Posting your solution could help others later with a similar problem.