Convert Many Invoice Formats to a Standard Format

[joeny0706]

OK, but they will be simple explicit questions that require a simple explicit declaratory answer, No explanations, no Train of Thoughts, no nothing but simple answers. Lets start from the beginning and work towards the ending.

1. When a Data file from a Distributor first appears on your computer, what Folder(s,) (complete Path, please,) is it [are they] located in? List all
2. What are the Naming Patterns each Distributor uses? Provide at least two examples of each
3. What File Types does each Distributor use for their Data Files?

[/QUOTE]



1. All the data files are emailed to me. Currently I save them in different places.
C:\FlexibakeConversions\Data
C:\Albany\data
C:\midstate\data
C:\ahold\Data
C:\kkb\data
2. C:\midstate\data\08.15.20_Recap.xlsx
C:\ahold\Data\0056919000647_0004353672.csv
C:\FlexibakeConversions\Data\HEIDELBERG-INVCR092220.csv
3. .xlsx
.csv


I will provide some of the files and you can see the formats