Project LID Homepage: Distributable Modules
Updates
Update 12/1/2022: Upgrade: function for parsing delimited lines expanded for more data format scenarios.
Update 8/29/2022: Update: if last source column is empty, still used in processing.
Update 8/25/2022: Upgrade: Add Combined Count Column Row.
Update 7/19/2022: Upgrade: Added ASCII code support for Combine and Concatenate delimiters. Bug fix: concatenation of columns was not working if first combined row was empty in that column.
Update 7/7/2022: Upgrade: upgraded processing output. Added key "lcc:fileSetSourceColumnFlag".
Update 6/30/2022: Program released.
Description
Combines rows/columns from one file into another.
Capabilities:
- specify the columns you are reading from a file
- specify the columns you want written to a file
- specify which source column(s) are the "Primary Key"
- read the source file lines from top to bottom
- when two or more rows match on the Primary key column(s), automatically combine them
- specify which columns it should combine, the others will be left as-is from the first row matched
- specify which delimiter/value used to separate multiple values in a column
- specify which columns should be concatenated with each other, and in which order (i.e. source+target, or target+source)
- specify which delimiter/value used to separate concatenated columns
- prepend static data to a column, like "PREFERRED_NAME:", "JOB:", etc.
Installation
Documentation
Disclaimer
The programs, scripts and documentation are provided AS IS without warranty of any kind. Lower Columbia College further disclaims all implied warranties including, without limitation, any implied warranties of merchantability or of fitness for a particular purpose. The entire risk arising out of the use or performance of the programs, scripts and documentation remains with you. In no event shall Lower Columbia College, its authors, or anyone else involved in the creation, production, or delivery of the programs, scripts or documentation be liable for any damages whatsoever (including, without limitation, damages for loss of business profits, business interruption, loss of business information, or other pecuniary loss) arising out of the use of or inability to use the programs, scripts or documentation, even if Lower Columbia College has been advised of the possibility of such damages.