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.
More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.
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…
Active Directory replication delay is the cause to many problems. Here is a super easy script to force Active Directory replication to all sites with by using an elevated PowerShell command prompt, and a tool to verify your changes.
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…