Hello everyone, I need help with this case, I have an excel table which contains specific information to be able to find a pdf file in a folder without using a loop, due to the large number of files that the folder hosts
the name of the files has the following structure:
T01_C50601092100040157037000100001010000002288195183772_E401570370_R3101375519_F20210901_Chocolates_.pdf
T01 → It is static
C506 → It is static
010921 → makes redeference to document date 09/01/2021
000401570370 → is the issuer id (identificacion in excel table)
00100001010000002288 → Invoice (N Fact Electronica in excel table)
195183772 → dynamic random number
E401570370 → Again the issuer id (Identificacion in excel table)
R3101375519-> Receiver Id
F20210901-> Document date again
It will only result in a pdf file, there may be several files with the same invoice or with the same issuer id, but only one with the corresponding invoice and issuer id