Consulting

Results 1 to 3 of 3

Thread: Generate Condition CSV File

  1. #1

    Generate Condition CSV File

    Good evening,
    I have a CSV file that is generated daily, I need a macro that when executed read this file and create a CSV copy only of the lines where column D is equal to USD and EUR.
    Thank you
    Attached Files Attached Files

  2. #2
    VBAX Guru Kenneth Hobs's Avatar
    Joined
    Nov 2005
    Location
    Tecumseh, OK
    Posts
    4,911
    Location
    That is not a CSV file. It is a semi-colon delimited text file.

    I suspect that you want the rows with either USD or EUR in the 4th column.

    It is not clear if you want the new "CSV" file to contain the title row or not. It is not clear if this new file should be a true CSV file or a semi-colon delimited text file. Is the 20200521.csv file open?

    Addressing the items above would govern the solution path.

  3. #3
    Good afternoon,
    As requested, follows:
    - Yes, I need it to contain the titles;
    - It must be a true CSV;
    - The file 20200521.csv is not open.


    Thank you

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •