Project LID Homepage: Distributable Modules
Updates
Update 6/9/2020: Bug fix: when using Math "Math: If <=, Replace", "Math: If >= and <=, Replace", "Math: If >=, Replace" on decimal values.
Update 4/22/2020: Upgrade: streamlined multiple modules for faster processing.
Update 11/28/2018: Bug fix on comma delimited source files, in regards to lcc:recordsMaxLoad not working.
Update 3/10/2017: Debug information errata on single key reference fixed.
Update 2/24/2017: Manual spelling mistake on key name fixed.
Update 6/16/2016: Upgraded, added 'Current' to key 'lcc:actionTwoToFourYearThreshold'.
Update 5/10/2016: Upgraded, added Action Type 'Split On Position'.
Update 5/9/2016: Upgraded, added lcc:actionFlag values 'Right To Left', 'Keep Left Over'.
Update 3/23/2016: Upgraded, added Action Type 'Insert Line At Each Record Set', new Convert To Original Format 'HHMMA/P', New Format 'HH:MM AM/PM'.
Update 3/21/2016: Upgraded, added lcc:actionFlag value 'DecimalPlaces:#'.
Update 3/16/2016: Upgraded, added Special Values replacing in Column Value Key.
Update 3/15/2016: Upgraded, handle if incorrect delimiter supplied in Logic File, added new format YYYY-MM-DD, added Keep First, Keep Last to Combine Duplicates, added Replace.
Update 2/24/2016: Upgraded 'Insert Empty Columns' to handle insert beyond farthest column number.
Update 2/1/2016: Added Microsoft/Unix Time Stamp in Convert To action. Added Action Flags.
Update 1/21/2016: Added Keys: "Lower Case", "Upper Case", "Append Columns", "Remove Columns". "Trim", "Trim Left", "Trim Right", "Remove Consecutive Spaces"
Update 1/20/2016: Upgraded Camel Case process.
Update 1/19/2016: Added White Paper (scenario) for Need Report
Update 1/19/2016: Added Keys: "Keep Records With Column Value Containing", "Skip Records With Column Value Containing", "If Empty, Place Value", "If Not Empty, Place Value", "Keep Records With Empty Column", "Keep Records With Not Empty Colulmn", "Skip Records With Empty Column", "Skip Records With Not Empty Column". Bug fix: sort as number.
Update 1/12/2016: Manual upgraded to provide more examples, fix some erratas.
Update 1/11/2016: Program released.
Description
LCCColumnsCruncher was created to load one to many files (Data Sets), and allow multiple types of actions against/between the data, and finally produce one to many output files.
Others LCC tools suggested for this type of need:
Capabilities
- Append: append value to value in column
- Append Columns: append columns
- Camel Case: camel case value in column
- Capitalize: capitalize value in column
- Combine Duplicates, Append: combine records on defined unique column(s) value, appending additional matches
- Combine Duplicates, Keep First: combine records on defined unique column(s) value, only the first match
- Combine Duplicates, Keep Last: combine records on defined unique column(s) value, only the last match
- Combine Sets: combine records from one Data Set to end of another Data Set.
- Convert To: convert column value into another data format
- Empty Column When Another Column Value Not Supplied: clear column value
- Find Duplicates: find duplicate records according to unique column(s) value
- Find Match And Insert: find matching record on one memory file and insert value into another memory file
- Find Match And Replace: find matching record on one memory file and replace value in another memory file
- If Empty, Place Value: if a column value is empty, place a value
- If Not Empty, Place Value: if a column value is not empty, place a value
- Insert Blank Columns: insert blank columns
- Insert Line At Each Record Set: insert a new line (record) after each new record set
- Keep Records With Column Value: keep records that have defined value(s), discard the rest
- Keep Records With Column Containing: keep records that contain defined value(s), discard the rest
- Keep records with Empty Column: keep records that have an empty column
- Keep records with Not Empty Column: keep records that have a not empty column
- Lower Case: lower case value in column
- Math: If <=, Replace: compare number value in column and replace a column value if true
- Math: If >= and <=, Replace: compare number value in column and replace a column value if true
- Math: If >=, Replace: compare number value in column and replace a column value if true
- Math: Multiply: multiply value in column by a number
- Pad Left: left pad a column value with a character
- Pad Right: right pad a column value with a character
- Prepend: prepend value in column
- Remove Columns: remove columns
- Remove Consecutive Spaces: remove spaces where there are more than one in a consecutive position
- Replace: replace values inside a column value
- Skip Records With Column Value: skip records that have defined value(s), keep the rest
- Skip Records With Column Value Containing: skip records that contain defined value(s), keep the rest
- Skip records with Empty Column: skip records that have an empty column
- Skip records with Not Empty Column: skip records that have a not empty column
- Sort: sort all records on a column
- Split On Character: split the value in a column into multiple columns
- Split On Position: split the value in a column into multiple columns
- Swap Columns: swap columns
- Trim: remove white-space characters from the left and right of the column
- Trim Left: remove white-space characters from the left of the column
- Trim Right: remove white-space characters from the right of the column
- Upper Case: upper case value in column
Installation
Documentation
Screenshot