Trying to get our source files in best possible shape so they load to database faster. I have a text file that is pipe delimited. It has 14 fields. First 4 are metadata and last 10 are data. Here's what I need.
For each field:
Field 1 - Nothing - Stays as is
Field 2 - Change 'Fiscal Rcpt' to 'Fiscal' and 'Fiscal Sales' to 'Fiscal'. So 'Fiscal Sales Aug' would be 'Fiscal Aug' and so on.
Field 3 - Nothing - Stays as is
Field 4 - Change '2012' to '2012_New'
Field 5 to Field 14 - Change '0' to #Missing and/or '0.00' to #Missing. These have to be exact matches only. So 50 cant become 5#Missing. Only '0' and '0.00' can be changed to #Missing.
This has to run as fast as possible as this is whole point as we are bumping up against SLA already. I have a bunch more of these so some way where I can change a few things around for a different file would be helpful too.
So a way where I can identify the filename to apply this to and then the resulting file would just be prefixed with 'LD_'. That would be great.
I appreciate all help you gurus have been providing.
Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.
When designing a form there are several BorderStyles to choose from, all of which can be classified as either 'Fixed' or 'Sizable' and I'd guess that 'Fixed Single' or one of the other fixed types is the most popular choice. I assume it's the most p…
Get people started with the process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…