Solved

Remove and add an extension.

Posted on 2007-03-21
1
125 Views
Last Modified: 2010-04-23
strCSVZipFlatFileName = StrFileName & ".zip"


There is a bug above and we need to make sure that the below .csv is replace by .zip.
What should I do to replace the above to conform to this?
"C:\SourceControl_mcupryk\InHouseDev\INTRANET\Intranet_DEVEL_2005\StoreSupply\AssignmentEGCNumber\tmpdownload\P.safeway_assigned.20070321_1034.csv"
0
Comment
Question by:mathieu_cupryk
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 67

Accepted Solution

by:
sirbounty earned 250 total points
ID: 18764241
strCSVZipFlatFileName = Replace(StrFileName, ".zip", ".csv")

or more .net~ish...

strCSVZipFlatFileName = StrFileName.Replace(".zip", ".csv")

0

Featured Post

Secure Your Active Directory - April 20, 2017

Active Directory plays a critical role in your company’s IT infrastructure and keeping it secure in today’s hacker-infested world is a must.
Microsoft published 300+ pages of guidance, but who has the time, money, and resources to implement? Register now to find an easier way.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction When many people think of the WebBrowser (http://msdn.microsoft.com/en-us/library/2te2y1x6%28v=VS.85%29.aspx) control, they immediately think of a control which allows the viewing and navigation of web pages. While this is true, it's a…
Parsing a CSV file is a task that we are confronted with regularly, and although there are a vast number of means to do this, as a newbie, the field can be confusing and the tools can seem complex. A simple solution to parsing a customized CSV fi…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
How to Install VMware Tools in Red Hat Enterprise Linux 6.4 (RHEL 6.4) Step-by-Step Tutorial

726 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question