I got a mapping sheet where invoice is written
299179
846142
525401
124709
563188
163594
727446
556845
301034
497634
30356
710143
638564
861102
and folder where pdf invoice is there, but the issue is pdf name is bit tricky.
299179_smith_27-12-2021.pdf.
846142_farhan_17-10-2021.pdf
task is I have to create a folder by invoice number and upload the invoice pdf.
I can get the pdf path but comparing it with the invoice number is quite hard for me.
can you please help me, how to do it.