Textpad – Best Text Editor for Regex operations, customizable color coding.

TextPad is a powerful, general purpose editor for plain text files. Easy to use, with all the features a power user requires.

Advanced search/replace, Spellcheck, Syntax-Highlighting, Line Numbering, Multiple Document Handling, Macros, minimize to tray, windows shell integration. You can also setup line highlighting for emphasizing what line of a computer program you are on.

Based on the requests from users, I have uploaded ERwinSQL.syn customized with oracle sql, plsql syntax. You can download it and move this to “C:\Program Files\TextPad 4\Samples” directory. You may need to create a SQL class and link this to sql class in textpad. If you need step by step instruction, feel free to comment at the end. I will help you fix it

It can open big text files for editing or mass editing. It has the best regular expression capabilities that is very useful for mass editing. It has full-featured trial versions for evaluation purpose.

Case Study:Recently, we had a situation to correct 2 million records in a production system data file. The file had an wrong format data at about fifty columns. Hence, we need to replace fifty chars string with different locations. Wherever the search matches, the data must be replaced. However, it should not replace any match in the other areas. For example, Single row has 400 bytes length and the City information is stored between 180 to 200 char position. Wherever “San Jose” comes between 180-200 position must be replaced with “San Jose,TX” for the 2 Millions records. It should not change any “San Jose” in other columns i.e., from 1 to 180 and 201 to 400 chars. Yes, this is successfully modified, within 5 minutes, using Textpad.

Single user license costs $30. It’s completely free upgrades, so you won’t buy over and over again, and there are free AddOns and Syntax Definitions you can download from their website. For programmers and companies this is very useful for data conversion. It has online forum support, and customizable color coding plugins.

TextPad is a great program, and I recommend you buy it!

Question: Can TextPad replace null?
Answer: I do not see any workaround using textpad. use unix tr utility to remove.

Can I replace carriage return using textpad?