Photo Gallery Member List Search Calendars FAQ Ticket List Log Out


Remove Text Qualifier, Save File - Noobie Question

  		Logged in as: Guest
arrSession:exec spGetSession 2,2,64725
Active Users: There are 0 members and 0 guests.
Users viewing this topic: none
 

 

  
 
  Printable Version
All Forums >> [Scripting] >> WSH & Client Side VBScript >> Remove Text Qualifier, Save File - Noobie Question
  Do you like VisualBasicScript.com? Link to us and help spread the word about our forum. Thanks! 		Page: [1]
Login
Message << Older Topic   Newer Topic >>
Remove Text Qualifier, Save File - Noobie Question - 10/2/2008 5:02:05 AM   
  kriemer


Posts: 29
Score: 0
Joined: 9/26/2008
Status: offline 		I have a csv file where some of the files have the text qualifier "" which I would like to remove.

I have found the following code which purports do this; trouble is that I lack the skill to modify it to point to my file (C:\test.aqd).  Additionally once modified I need to save the file under a new name.

Can anyone help me please.

Thanks in advance.

k



      
 
 
Post #: 1
 
RE: Remove Text Qualifier, Save File - Noobie Question - 10/2/2008 7:05:41 AM   
  Fredledingue


Posts: 383
Score: 0
Joined: 5/9/2005
From:
Status: offline 		This should do it, (with less lines of code).


      

_____________________________

Fred

(in reply to kriemer)
 
 
Post #: 2
 
RE: Remove Text Qualifier, Save File - Noobie Question - 10/2/2008 7:09:49 AM   
  kriemer


Posts: 29
Score: 0
Joined: 9/26/2008
Status: offline 		Sorry to be obtuse (you have no idea how sorry I am) but how do I point this to my input file "C:\test.aqd"? 

Also, am I correct that the file will be saved as "TEMP.txt" (and I just modify this with a path and appropriate file name)?


Thanks and Whoo Hoo!!!

k

< Message edited by kriemer -- 10/2/2008 7:21:05 AM >

(in reply to Fredledingue)
 
 
Post #: 3
 
RE: Remove Text Qualifier, Save File - Noobie Question - 10/2/2008 7:29:06 AM   
  htac

 

Posts: 12
Score: 0
Joined: 10/2/2008
Status: offline 		You have to replace WScript.Arguments.Item(0) with the path to your file.

Like: Set s = fso.OpenTextFile("C:\test.aqd", 1, True)

(in reply to kriemer)
 
 
Post #: 4
 
RE: Remove Text Qualifier, Save File - Noobie Question - 10/2/2008 8:07:51 AM   
  kriemer


Posts: 29
Score: 0
Joined: 9/26/2008
Status: offline 		Works perfectly


      

10^6 Thanks

k

< Message edited by kriemer -- 10/2/2008 8:24:55 AM >

(in reply to htac)
 
 
Post #: 5
 
 
 
 

If you found our site useful please link to us <a href="http://www.visualbasicscript.com">VisualBasicScript.com</a>.
All Forums >> [Scripting] >> WSH & Client Side VBScript >> Remove Text Qualifier, Save File - Noobie Question Page: [1]
Jump to:





New Messages No New Messages
Hot Topic w/ New Messages Hot Topic w/o New Messages
Locked w/ New Messages Locked w/o New Messages
 Post New Thread
 Reply to Message
 Post New Poll
 Submit Vote
 Delete My Own Post
 Delete My Own Thread
 Rate Posts




Forum Software © ASPPlayground.NET Advanced Edition 2.5.5 ANSI