Columnizer, version 5.38

Columnizer

Columnizer is a special program for working with column and row data.

Columnizer

Columnizer button features / processing examples:

(click on button to go to example)

	Attempt to realign HTML
	Insert into a column of data
	Insert a column of data
	Copy a column of data
	Retain / Delete a column of data
	Replace data within a column
	Insert spread sheet separation character
	Insert a row
	Delete a row of data
	Delete blank lines
	Retain / Delete lines per data
	Insert lines per data
	Insert a carrage control
	Vertical column concatenation
	Insert incrementing letters
	Replace line per data
	Horizontal column concatenation

	Append lines per data
	Retain / Delete starting at specified data
	Insert data within line Before / After specified data
	Replace data with a top-down data list
	Align all data into columns
	Shuffle data
	Find and mark duplicate lines
	Replace with special characters
	Insert incrementing numbers
	Delete leading / trailing blanks
	Format for ReadMe
	Special Routines
	Sort Ascending / Descending and Reverse order
	Convert data to Courier font
	Total a specified column
	Break up file records
	Replace any character within a file

Attempt to realign HTML (Before is result of a copy and paste from a web page)

Before	After
Month Daily Avg Monthly Totals Hits Files Pages 3600 2726 224	Month Daily Avg Monthly Totals Hits Files Pages 3600 2726 224

Insert into a column of data (inserted at column 7)

Before	After
aaaaaaaaaaaaa aaaaaaaaaaaaa aaaaaaaaaaaaa aaaaaaaaaaaaa aaaaaaaaaaaaa aaaaaaaaaaaaa aaaaaaaaaaaaa	aaaaaaINSERTED DATAaaaaaaa aaaaaaINSERTED DATAaaaaaaa aaaaaaINSERTED DATAaaaaaaa aaaaaaINSERTED DATAaaaaaaa aaaaaaINSERTED DATAaaaaaaa aaaaaaINSERTED DATAaaaaaaa aaaaaaINSERTED DATAaaaaaaa

Insert a column of data (column inserted between two columns)

Before	After
Line1 333 Line2 999 Line3 333 Line4 444 Line5 555	Line1 999 333 Line2 222 999 Line3 333 333 Line4 999 444 Line5 999 555

Copy a column of data (3rd column copied and inserted between 1st two columns)

Before	After
Line1 999 333 Line2 222 999 Line3 333 333 Line4 999 444 Line5 999 555	Line1 333 999 333 Line2 999 222 999 Line3 333 333 333 Line4 444 999 444 Line5 555 999 555

Retain / Delete a column of data

Before	After
111 222 333 444 555 111 222 333 444 555 111 222 333 444 555 111 222 333 444 555 111 222 333 444 555 111 222 333 444 555 111 222 333 444 555	(column 444 deleted) or (column 444 retained) 111 222 333 555 444 111 222 333 555 444 111 222 333 555 444 111 222 333 555 444 111 222 333 555 444 111 222 333 555 444 111 222 333 555 444

Insert a row of data ('-- insert --' inserted every 2 rows)

Before	After
aaaaaaaaaaaaa aaaaaaaaaaaaa aaaaaaaaaaaaa aaaaaaaaaaaaa aaaaaaaaaaaaa aaaaaaaaaaaaa	aaaaaaaaaaaaa aaaaaaaaaaaaa -- insert -- aaaaaaaaaaaaa aaaaaaaaaaaaa -- insert -- aaaaaaaaaaaaa aaaaaaaaaaaaa -- insert --

Delete a row of data (every 3rd row deleted)

Before	After
aaaaaaaaaaaaa aaaaaaaaaaaaa -- delete -- aaaaaaaaaaaaa aaaaaaaaaaaaa -- delete -- aaaaaaaaaaaaa aaaaaaaaaaaaa -- delete --	aaaaaaaaaaaaa aaaaaaaaaaaaa aaaaaaaaaaaaa aaaaaaaaaaaaa aaaaaaaaaaaaa aaaaaaaaaaaaa

Delete blank lines.

Before	After
aaaaaaaaaaaaa aaaaaaaaaaaaa aaaaaaaaaaaaa aaaaaaaaaaaaa	aaaaaaaaaaaaa aaaaaaaaaaaaa aaaaaaaaaaaaa aaaaaaaaaaaaa

Retain / Delete lines per data (lines containing bbb retained/deleted)

Before	After
1111111111111 2222222222222 3333333bbb333 4444444444444 5555555bbb555 6666666666666 7777777777777	(line deleted) or (line retained) 1111111111111 3333333bbb333 2222222222222 5555555bbb555 4444444444444 6666666666666 7777777777777

Insert lines (before/after) per data ('INSERTED DATA' inserted below lines containing bbb)

Before	After
111bbb11111111 22222222222222 33333333bbb333 44444444444444 55555555555555 66666666666666	111bbb11111111 INSERTED DATA 22222222222222 33333333bbb333 INSERTED DATA 44444444444444 55555555555555 66666666666666

Insert a carriage control (break lines at position 6)

Before	After
a1234567890 b1234567890 c1234567890 d1234567890	a12345 67890 b12345 67890 c12345 67890 d12345 67890

Vertical column concatenation (concatenate columns 5 through 7 with column 1)

Before	After
Line1 Line2 Line3 Line4 Line5 Line6 Line7	Line1 Line5 Line2 Line6 Line3 Line7 Line4

Horizontal column concatenation (concatenate each group of three rows horizontally)

Before	After
Line1 Line2 Line3 Line4 Line5 Line6 Line7	Line1 Line2 Line3 Line4 Line5 Line6 Line7

Insert incrementing numbers (every nth row option available)

Before	After
aaaaaaaaaaaaa aaaaaaaaaaaaa aaaaaaaaaaaaa aaaaaaaaaaaaa aaaaaaaaaaaaa aaaaaaaaaaaaa aaaaaaaaaaaaa	aaaaaa1aaaaaaa aaaaaa2aaaaaaa aaaaaa3aaaaaaa aaaaaa4aaaaaaa aaaaaa5aaaaaaa aaaaaa6aaaaaaa aaaaaa7aaaaaaa

Insert incrementing character (every nth row option available)

Before	After
1234567890 1234567890 1234567890 1234567890 1234567890 1234567890 1234567890	12345a67890 12345b67890 12345c67890 12345d67890 12345e67890 12345f67890 12345g67890

Delete leading / trailing blanks

Before	After
aaaaaaaaa aaaaaaaaa aaaaaaaaa aaaaaaaaa aaaaaaaaa aaaaaaaaa aaaaaaaaa	aaaaaaaaa aaaaaaaaa aaaaaaaaa aaaaaaaaa aaaaaaaaa aaaaaaaaa aaaaaaaaa

Capitalize first character of each word or sentence, or convert to all upper / lower case

Before	After
any and all words	(all to upper example): ANY AND ALL WORDS (all to lower example): any and all words (1st letter of word example): Any And All Words

Setup text for ReadMe

Before	After
Take out special characters that are pronounced.

Sort Ascending / Descending (start column and reverse order options available)

Before	After
Line7 Line6 Line5 Line4 Line3 Line2 Line1	Line1 Line2 Line3 Line4 Line5 Line6 Line7

Convert data to Courier font (for proper alignment)

Before (ariel)	After
3600 2726 224 79 2868 1266 873 68 33 2515 2045 1128 88 43 3355 1618 785 67 38 2418 1241 864 72 42 2639 1090 884 71 39 2613 3848 3416 328 303 4794	3600 2726 224 79 2868 1266 873 68 33 2515 2045 1128 88 43 3355 1618 785 67 38 2418 1241 864 72 42 2639 1090 884 71 39 2613 3848 3416 328 303 4794

Append lines per data ('append this' appended to dataB)

Before	After
Line1 dataA Line2 dataB Line3 dataA Line4 dataA Line5 dataB	Line1 dataA Line2 dataB append this Line3 dataA Line4 dataA Line5 dataB append this

Replace data within a specified column (999 changed to 000 in column 2)

Before	After
Line1 999 111 Line2 222 222 Line3 333 333 Line4 999 999 Line5 555 555	Line1 000 111 Line2 222 222 Line3 333 333 Line4 000 999 Line5 555 555

Replace line per data (lines containing 999 changed to 'new line')

Before	After
Line1 999 111 Line2 222 999 Line3 333 333 Line4 999 999 Line5 555 555	new line new line Line3 333 333 new line Line5 555 555

Align all data into columns (left or right justify)

Before	After
Line1 4444 1 Line2 22 22 Line3 333 4444 55555 Line4 333 Line5 333 55555	Line1 4444 1 Line2 22 22 Line3 333 4444 55555 Line4 333 Line5 333 55555

Total a specified column (column 3 total = 555)

Before	After
Line1 999 (111) Line2 222 <222> Line3 333 333 Line4 999 -444 Line5 999 999	Total displayed in program interface.

Retain / Delete starting at specified data within a line (line deleted before data: 999)

Before	After
Line1 999 333 Line2 222 999 Line3 333 333 Line4 999 444 Line5 999 555	999 333 999 Line3 333 333 999 444 999 555

Insert data within line Before / After specified data (XXX inserted before data: 999)

Before	After
Line1 999 333 Line2 222 999 Line3 333 333 Line4 999 444 Line5 999 555	Line1 XXX999 333 Line2 222 XXX999 Line3 333 333 Line4 XXX999 444 Line5 XXX999 555

Break up single record file (carrage return / line feed inserted after every 5th character)

Before	After
1234567890abcdefghij1234567890klmnopqrst	12345 67890 abcde fghij 12345 67890 klmno pqrst

Insert spread sheet separation character (TAB inserted before second column)

Before	After
Line1 999 333 Line2 222 999 Line3 333 333 Line4 999 444 Line5 999 555	Line1 999 333 Line2 222 999 Line3 333 333 Line4 999 444 Line5 999 555

Shuffle date (shuffle lines starting at line 5)

Before	After
Line1 111 111 Line2 222 222 Line3 333 333 Line4 444 444 Line5 555 555 Line6 666 666 Line7 777 777 Line8 888 888	Line1 111 111 Line5 555 555 Line2 222 222 Line6 666 666 Line3 333 333 Line7 777 777 Line4 444 444 Line8 888 888

Mark duplicate lines

Before	After
Line1 111 Line2 222 Line3 333 Line2 222 Line1 111 Line2 222 Line4 444	1-->Line1 111 2-->Line2 222 Line3 333 2-->Line2 222 1-->Line1 111 2-->Line2 222 Line4 444

Replace data with special characters (Comma replaced with TAB for spread sheet)

Before	After
1,22,333 22,1,4444 333,22,1 4444,22,333 1,4444,22	1 22 333 22 1 4444 333 22 1 4444 22 333 1 4444 22

Special note: To convert Before to After with spaces inbetween, first use the 'Replace with Special Character' routine to replace the comma (or other dividing character) with a {CarriageReturn} character. Then use the 'Horzontal Concatination' routine (Symmetrical data) to space the data correctly.

Replace data with a top-down data list (222 replaced with a list = 'v, w, x, y, and z')

Before	After
Line1 222 333 Line2 222 999 Line3 222 333 Line4 222 444 Line5 222 555	Line1 v 333 Line2 w 999 Line3 x 333 Line4 y 444 Line5 z 555

Download Columnizer (646 kB)

News:

Links

Freeware Guide
321Download
FreewareUpdates