Importing a comma delimited textfile

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Anthony1312002
    New Member
    • Sep 2006
    • 12

    Importing a comma delimited textfile

    I have a working script that imports a space or tab delimited textfile using the vbTab attribute. But because of an upgrade the file has now become comma delimited. what would I need to change to make this script work with the new file format?

    strTextLine=obj Text.Readline
    data=Split(strT extLine,vbTab)

    RLog.AddNew
    RLog("fldUnknow n")=data(0) 'Site ID
    RLog("fldAccoun tName")=data(1) 'Client ID
    RLog("CustomerN ame")=data(2) 'Client Name
  • jhardman
    Recognized Expert Specialist
    • Jan 2007
    • 3405

    #2
    [code=asp] data=Split(strT extLine,",")[/code]

    Comment

    Working...