S
Steve_A
I tried to search for this but I am not sure how to search it.
I have “Table1†with a PN field and I need to join that to the PN field in
“TableA†but it is buried in a string. Is this possible as it is not always
at the start or end of the string? I can go get them one at a time using
*148T5-400* but that will take a while doing several hundred
Table1 TableA
PN PN
148T06-905-400 MOD/148T06-905-400ER/R1
148T06-905-400 148T06-905-400ER/R2
148T06-905-400 DEVIATION/148T06-905-400
148T06-905-400 MOD/148T06-905-400
141A68-1 M0D/141A68-1
141A68-1 141A68-1PIA
141A68-1 REVA141A68-1PIA
TIA
I have “Table1†with a PN field and I need to join that to the PN field in
“TableA†but it is buried in a string. Is this possible as it is not always
at the start or end of the string? I can go get them one at a time using
*148T5-400* but that will take a while doing several hundred
Table1 TableA
PN PN
148T06-905-400 MOD/148T06-905-400ER/R1
148T06-905-400 148T06-905-400ER/R2
148T06-905-400 DEVIATION/148T06-905-400
148T06-905-400 MOD/148T06-905-400
141A68-1 M0D/141A68-1
141A68-1 141A68-1PIA
141A68-1 REVA141A68-1PIA
TIA