Sample/prototype rexx to trim down CSV-data out of Endevor's CSV-Utility

File uploaded by josef.thaler on Nov 3, 2014Last modified by josef.thaler on Nov 12, 2014
Version 5Show Document
  • View in full screen mode

If you work with Endevor's CSV-utiliy and would like to tailor the extracted csv-data, but don't like to check and count columns in a NOCSV-formatted file, you might benefit from the prototype-rexx provided here.

 

Please note, this is just a quick realization of an idea, which satisfies our current needs, there is no warranty at all. If you like to use it, you can further develop (and debug) the rexx and share it here. And of course, it would be more than nice, if this functionality could be included in Endevor itself.

 

Extract from the doc's/info's contained in the source; You can just invoke the rexx alone to get these lines written to //SYSTSPRT.)

 

$csvtrim.jpg

 

Rework(1): Rework all "^" from the source code -> "^=" -> "<>" and  "^like" -> "not_like"; add note concerning exclamation mark.

Rework(2): Some bugs corrected

Rework(3): One more bug detected and eliminated

Attachments

Outcomes