08-05-2014, 04:54 PM
Hello Gintaras,
The text that will be in the clipboard is the "08-05 Smith - Johnson -". The rest of the text after the last dash will change based on the quote that is being run. For example the full name of the PDF would look similar to this.
J:\Quotes\2014\08-05 Smith - Johnson - Gen $4500 Monthly 6yrs Shared 3% Comp.pdf
J:\Quotes\2014\08-05 Smith - Johnson - Comparison.pdf
J:\Quotes\2014\08-05 Smith - Johnson - Thrivent $4500 Monthly 6yrs Shared 3% Comp.pdf
J:\Quotes\2014\08-05 Somebody - Else - Gen $5000 Monthly 8yrs Shared 3% Comp.pdf
J:\Quotes\2014\08-05 Somebody - Else - Comparison.pdf
The goal is to attach all of the files in the example above that have the text "08-05 Smith - Johnson -". Also, because I am not the only one entering the names of the PDFs sometime the spaces between the dashes aren't there. However I can say with certainty all of the people running quotes are using "MM-DD Client LName - Advisor LName -" even if all of the spaces are not there.
Thank you for your help on this.
Paul
Gintaras Wrote:Do you want to find all these files assuming clipboard text is "TextInClipboard"?
J:\Quotes\2014\08-05 Smith - Johnson - TextInClipboard.pdf
J:\Quotes\2014\08-06 Smith - Johnson - TextInClipboard.pdf
J:\Quotes\2014\08-07 Somebody - Else - TextInClipboard.pdf
The text that will be in the clipboard is the "08-05 Smith - Johnson -". The rest of the text after the last dash will change based on the quote that is being run. For example the full name of the PDF would look similar to this.
J:\Quotes\2014\08-05 Smith - Johnson - Gen $4500 Monthly 6yrs Shared 3% Comp.pdf
J:\Quotes\2014\08-05 Smith - Johnson - Comparison.pdf
J:\Quotes\2014\08-05 Smith - Johnson - Thrivent $4500 Monthly 6yrs Shared 3% Comp.pdf
J:\Quotes\2014\08-05 Somebody - Else - Gen $5000 Monthly 8yrs Shared 3% Comp.pdf
J:\Quotes\2014\08-05 Somebody - Else - Comparison.pdf
The goal is to attach all of the files in the example above that have the text "08-05 Smith - Johnson -". Also, because I am not the only one entering the names of the PDFs sometime the spaces between the dashes aren't there. However I can say with certainty all of the people running quotes are using "MM-DD Client LName - Advisor LName -" even if all of the spaces are not there.
Thank you for your help on this.
Paul