dasfadsf
05-26-2016, 03:39 AM
hi, hope someone can help?
I have 4 columns :A,B,C,D
If A is more than 10 chars i want it copied to B and deleted from A
If C has more than 10 chars, i want it copied to D and deleted from C
If B or D aready have chars, and the contents of A or C are moving to them, i need the contents of A or B to go after the contents of C or D
I need a script as there are thousands of records and i need it to do it to every row
Thanks for the help!
before
Column A
Column B
Column C
Column D
supermarket
Sunday
jackhammers
Blue
after
Column A
Column B
Column C
Column D
Sunday, Supermarket
Blue, jackhammers
I have 4 columns :A,B,C,D
If A is more than 10 chars i want it copied to B and deleted from A
If C has more than 10 chars, i want it copied to D and deleted from C
If B or D aready have chars, and the contents of A or C are moving to them, i need the contents of A or B to go after the contents of C or D
I need a script as there are thousands of records and i need it to do it to every row
Thanks for the help!
before
Column A
Column B
Column C
Column D
supermarket
Sunday
jackhammers
Blue
after
Column A
Column B
Column C
Column D
Sunday, Supermarket
Blue, jackhammers