View source for Text Processor Examples

The Spring Tools [http://www.homemarketeer.com/tools/text_processor/text_processor.html Text Processor] is an amazingly versatile tool.

To show some of the things it can do, the links below give some varied examples of tricks that can be done. Each of these tricks is stored as part of the URL, so it can stored in a document or bookmarked ready for you to use at a moment's notice. 

=Text Processor Examples=

===List of Values to SQL List===

Switches a list of values (one to a line) into a comma separated, single quoted list enclosed on brackets (). Ripe for using in a SQL "in" list.

[http://www.homemarketeer.com/tools/text_processor/text_processor.html?c1=Unique&m1=gi&c2=Replace&e2=.*&t2=%27%24%26%27%2C&m2=gi&c3=Replace&e3=%5Cn&m3=gi&c4=Replace&e4=%5E&t4=%28&m4=gi&c5=Replace&e5=%24&t5=%29&m5=gi SQL List]

===Replace US Dates (mm/dd/yyyy) with European Style Dates (dd.mm.yyyy)===

Searches for dates in the format mm/dd/yyyy and switches them to the European style dd.mm.yyyy. Of course, you can chnage the separators to suit.

[http://www.homemarketeer.com/tools/text_processor/text_processor.html?c1=Replace&e1=%28%5B0-9%5D%7B1%2C2%7D%29/%28%5B0-9%5D%7B1%2C2%7D%29/%28%5B0-9%5D%7B2%2C4%7D%29&t1=%242.%241.%243&m1=gi US Date to UK Date]

===Making Text More Brit Friendly===

Replaces some of the more common spelling differences of American English to British English. Does it include your favourites?

[http://www.homemarketeer.com/tools/text_processor/text_processor.html?c1=Replace&e1=favorite&t1=favourite&m1=g&c2=Replace&e2=thru&t2=through&m2=g&c3=Replace&e3=color&t3=colour&m3=g&c4=Replace&e4=dialog&t4=dialogue&m4=g&c5=Replace&e5=catalog&t5=catalogue&m5=g&c6=Replace&e6=center&t6=centre&m6=g&c7=Replace&e7=defense&t7=defence&m7=g&c8=Replace&e8=neighbor&t8=neighbour&m8=g&c9=Replace&e9=honor&t9=honour&m9=g&c10=Replace&e10=behavior&t10=behaviour&m10=g US English to UK English]

===Extract Email Addresses===

Extracts all unique email addresses in your supplied text.

[http://www.homemarketeer.com/tools/text_processor/text_processor.html?c1=Replace&e1=%5Ba-zA-Z0-9%21%23%5C%24%25%26%27%5C*%5C+%5C-/%3D%5C%3F%5C%5E_%60%7B%7C%7D%7E%5C.%5D+@%5Ba-zA-Z0-9%5C-%5C.%5D+&t1=%0A%24%26%0A&m1=gi&c2=Replace&e2=%28%5Ba-zA-Z0-9%21%23%5C%24%25%26%27%5C*%5C+%5C-/%3D%5C%3F%5C%5E_%60%7B%7C%7D%7E%5C.%5D+@%5Ba-zA-Z0-9%5C-%5C.%5D+%29.*&t2=%241&m2=gi&c3=Match&e3=%28%5Ba-zA-Z0-9%21%23%5C%24%25%26%27%5C*%5C+%5C-/%3D%5C%3F%5C%5E_%60%7B%7C%7D%7E%5C.%5D+@%5Ba-zA-Z0-9%5C-%5C.%5D+%29&m3=gi&c4=Unique&m4=gi Unique Email Addresses]

=Other Links=
[[Text Processor]]
[[Tools]]