Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How do I find byte position in a table.

Status
Not open for further replies.

kat000003

Technical User
Jan 27, 2005
37
0
0
CH
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 ?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top