script: datas of one colomn into another one

[s-A]

Hi, I want to make a script that will put every datas of one colomns into another one, because if I do it manually, it will be pretty long to cut and paste everything, and I just have a week to finish this.

So is this possible?

It would save me a lot of time, so I could work on something else on that database I'm building.

Thank you!

[panchristo]

Maybe you should try clicking in the target column (ColumnB), type shortcut [Ctrl]+[=] and then specify a calculation such as: Table::ColumnA.

BTW, "data" is plural for "datum", so no such word as "datas". :

[s-A]

Oh really? Didn't know that. Anyway, thanks for the grammar tip :

And thanks for the answer, it has been really useful / helpful!

btw, sorry for my english, I'm not bilingual, so I kinda have some difficulties.

[Lee Smith]

Hi s-A, and welcome to the Forum.

There is nothing wrong with your english. I was able to understand your question.

A word of caution about using the Replace Function "cmd and =" (Menu >> Records >> Replace Field Contents) on your original file, as you can not UNDO your action. You should do this action on a copy of your file in case the inevitable unexpected happens.

Lee

[s-A]

Yeah, that's what I did, but thanks for the advice!

But now, what if I want to transfert the content of Colomn A into Colomn B, but only into Colomn B's blank field.

For example:

A: 80

B:

would become

A: 80

B: 80

But if it is

A:

B: 80

I don't want the content of A into the B field. Don't know if you understand, but I would like to do this?

[Lee Smith]

That is why I said to be careful of the Replace field contents, as you can not undo it. And, it doesn't care if there is data in the second field, it will replace it anyway.

What you need is a Found Set of Records that are blank in Field B. You can do this by going into Find Mode, and type the equal sign = in B.

Once you have the found set, then you can use the Replace on it, and it will not effect the other records that have been omitted.

HTH

Lee

[s-A]

Thanks so much, Lee! I can now work on something else, your help has been reeeeeeeeeeeally useful!

The big part of what I had to do this week is now done!

[Søren Dyhr]

But be careful to get replies, when asking this abstract ... it's not a database "kosher" request you have, why have the data landed in the wrong field in the first place??

I ask in this spiffy way to ensure nothing structural is the matter here. What is the context and purpose this should be performed ... if a word like syncronize shows up in your explanation you have made to yourself, might you consider that normalization is a mesure to seek to avoid the very thing!

--sd

[Lee Smith]

..... why have the data landed in the wrong field in the first place??

Excellent question, and one that I meant to asked, but forgot.

Lee

[s-A]

They were in the wrong field, because when I first created the coloums, there was "Amount" and "No. doses", but I didn't know that the number that was in te "Amount" field corresponded to the no. of doses, so some informations were into the "Amount" colomn, and other into the "No. doses" one. So when I learned they were the same, I just wanted to match them together.