Post reply

Getting date from first line of txt file.

  • April 4, 2011 at 3:50 pm

    #145336

    I have a delimited text file. It contains an "as of" date as part of the first line. I need to get the date in order to see if the file has already been imported. If it were an Excel file, I could specify the cell, but I have no idea how to do this in a text file. Could someone please point me in the right direction? Here is a sample of the file.

    "C O N F I D E N T I A L AS OF DATE 03/26/11"

    "VEND#","VENDOR NAME","BUYER#","BUYER NAME"

    "U000","XXXXXXXX YYYYYYYY - SECURITY ","7821","JANE DOE"

  • April 5, 2011 at 6:33 am

    #1307395

    I would use a Script Task to read line one of the file and then use a function to manipulate the workflow towards or away from processing the file per the value of the date you find.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply