Data manipulation - File tweaking, extracting, counting, summing, etc.

Some files are way larger in size simply because they contain spaces at the end of each line. If you are sending a file with a 500,000 rows on it, this can be a huge waste of space. This text tweak example shows you how to use right trim feature. Right trim will remove all the spaces at the end of every line. I have highlighted the data so you can see the spaces at the end of the line, and the before and after result after trimming the data.

Here are the sample results that will open in notepad. Text Tweak always opens up the results in a notepad text file, so you may copy and paste elsewhere or work with the results in any other application. You can see the spaces on the right are now removed, and the end result is the file will be much smaller in size without the wasted bytes on the end.

More data or file tweaking examples
Go to main page

Please feel free to link directly to this page.