Plutark
10-27-2008, 03:20 AM
Hi I am new to the forum, so Hi to everyone!
I have a project to work on at work.
What I need to do is :
I have a list of all the journals/invoices which have been posted in the system during the month.
I need to check on the shared folder if the people have put the copy of the journal as a back up. So far I have found a script to list all the items in the shared folder and the sub folders.
The problem is we have litteraly thousands of postings made per month. So I need to find a way to check if there is any missing journal in the shared drive.
the way we name the journals is "document number + name of the transaction". I only need to check the document number.
to summarize I need:
-A way to clean the list I have and only keep the document numbers
-Compare and signals missing files
Do you know if there is any formula that might help me do that? I don't need the whole formula, just where I should be looking etc...
thank you for your help, I think I am gonna spend time on this forum, find it through suggestions from my Google Reader, I guess he knew I was desperate to find a solution : pray2:
Plutark
I have a project to work on at work.
What I need to do is :
I have a list of all the journals/invoices which have been posted in the system during the month.
I need to check on the shared folder if the people have put the copy of the journal as a back up. So far I have found a script to list all the items in the shared folder and the sub folders.
The problem is we have litteraly thousands of postings made per month. So I need to find a way to check if there is any missing journal in the shared drive.
the way we name the journals is "document number + name of the transaction". I only need to check the document number.
to summarize I need:
-A way to clean the list I have and only keep the document numbers
-Compare and signals missing files
Do you know if there is any formula that might help me do that? I don't need the whole formula, just where I should be looking etc...
thank you for your help, I think I am gonna spend time on this forum, find it through suggestions from my Google Reader, I guess he knew I was desperate to find a solution : pray2:
Plutark