I have 2 tables as defined below.
I need the reulting table as defined below.
The process should be ;
for each string in column 1 of table A.
find string in column 1 of table B
return byte position in table B (ie byte poition
in full table starting from row 1 col 1
Not just position in the row)
update string BNo in table A with the above byte
position
end loop
===========================================
Table A
111,BNo,"A lot of stuff"
44,BNo,"A lot of stuff"
647,BNo,"A lot of stuff"
Table B
123,"Stuff",44,"Stuff"
44,"Stuff",544,"Stuff"
111,"Stuff",511,"Stuff"
999,"Stuff",647,"Stuff"
Result
111,45,"A lot of stuff"
44,23,"A lot of stuff"
647,0,"A lot of stuff"
IS THIS POSSIBLE ?
I need the reulting table as defined below.
The process should be ;
for each string in column 1 of table A.
find string in column 1 of table B
return byte position in table B (ie byte poition
in full table starting from row 1 col 1
Not just position in the row)
update string BNo in table A with the above byte
position
end loop
===========================================
Table A
111,BNo,"A lot of stuff"
44,BNo,"A lot of stuff"
647,BNo,"A lot of stuff"
Table B
123,"Stuff",44,"Stuff"
44,"Stuff",544,"Stuff"
111,"Stuff",511,"Stuff"
999,"Stuff",647,"Stuff"
Result
111,45,"A lot of stuff"
44,23,"A lot of stuff"
647,0,"A lot of stuff"
IS THIS POSSIBLE ?