If the user selects the model number(one table) Q4Sd-x24k and i am getting relative spartmodel(is in another table) Q4%,
Q4SA%D and Q4SD% (they are spartmodel data in a table)
and i have to fetch only Q4Sd% and need to get the PDF file belogns to that Q4SD%.
iam adding one more sample also.
model number : B4VM-x24k-B and
Spartmodel data : B4VM% and B4VM-E% i will get. i have to get only B4VM% pdf file.
Some times i have to match last letter also . like
model number : JT4BD-060C
and spartmodeldata: JT4BD% and JT4BD%C
so i have to get only JT4BD%C becoz its matching last letter also.
Here is sample data
| ModelNumber |
SPartModel |
SdocumentName |
| |
|
|
| JT4BD-060C |
JT4BD% |
JT4BD.pdf |
| |
JT4BD%C |
JT4BD-C.pdf |
| |
|
|
| B4VM-x24k-B |
B4SM% |
B4SM.pdf |
| |
B4VM% |
B4VM.pdf |
| |
B4VM-E% |
B4VM-E.pdf |
| |
|
|
| MSH4BF024KA |
MSH4BD% |
MSH4BD% |
| |
MSH4BE% |
MSH4BE.pdf |
| |
MSH4BF%A |
MSH4BF-KA.pdf |
| |
MSH4BF%B |
MSH4BF-KB.pdf |
let me know if needs any other information.
