Script/GUI to Format CSV File from Filenames in Directory

Public Clarification Board

Sharing of contact details is prohibited by the Terms of Service.

Post Message

• 

  flux627

  Hello everyone,
  
  I have two things to address.
  
  1. There are two more small features that I would like to be included in this program. The first is a checkbox option labeled 'Use Product Code'. When the checkbox is checked, the script should run normally, as I have described before. If the box is unchecked, then the script should run the same, except instead of the third comma delineated value being [FILE-NO-EX][TXT-VAR][NUM-VAR1], it is simply nothing. It is important, however, that the commas that surrounded the value before stay intact. In other words, when the checkbox is unchecked, every line in the output CSV should be in this format:
  
  [FILE1](spacer)[FILE2],[NUM-VAR1],,[NUM-VAR2],[FILE-NO-EX](space)[PRDCT]
  
  The second feature I would like in addition, is another checkbox labeled 'Order Values by CSV'. When this is not checked, the script should run as previously specified. When this is checked, when the the list is ordered according to the [NUM-VAR1] variable, it follows the corresponding order of the respective values in the input CSV file, instead of by ascending numerical order.
  
  
  2. It has come to my attention that many of you need further clarification in relation to the [NUM-VAR1] variable. I think the best way to do this is to give some example inputs and example outputs. This will also be useful to confirm those who are confident with understanding. Examples 1-5 demonstrate how the [NUM-VAR1] works, 6 demonstrates how targeting single files works, 7 demonstrates how file pairing works, and 8-10 demonstrate how different ordering works.
  
  Please Refer to attached file for examples.
  
  Also, please let me know if my additions have any affect your project bid price.
  
  Thanks,
  - J

  Attachment: csvformatterexamples.rtf

  over 2 years ago

• 

  flux627

  I have accidentally left two lines in the attached file that should have been removed before posting. These lines could cause some confusion as to exactly what I need done in this program. Attached here is the correct version.
  
  Thanks,
  J

  Attachment: csvformatter.rtf

  over 2 years ago

Show more messages