![]() Insert line breaks according to the specified number of characters (50, 60 or 70 characters).Convert text to "internet-friendly text".set up a notification when a certain number of characters or words is reached.convert a string into hexadecimal information.Change all dates in a certain format (YYYY-MM-DD, DD-MM-YYYY or similar).Randomize all rows (randomize) - I will use this to determine the winners in my raffles in the future!.reverse the sequence of all words in the text.Sort the rows (ascending or descending).Get all URLs out of a text and then attach them as a list to the original text. ![]() In order to briefly introduce a few more routines, I have put together a small list here, but it does not cover all the possibilities by far. There are also functions that convert between DOS, Unix and Mac line breaks back and forth. There is also a function for this in TextSoap that cleans up such things. For example, if you have a mail that contains quotations from an earlier mail, these are often shown with a preceding square bracket ">". In addition to such corrections of words or punctuation, there are also many functions that affect the form of the text. An "Iphone" then automatically becomes an "iPhone" - even if the Mac itself usually offers this as a correction when typing. There are even features that correct the spelling of product names from big tech companies. The Mac software TextSoap, on the other hand, is a small marvel for this area of application, because it offers so many ready-made cleaning functions that hardly anything is left to be desired. Every now and then I need single quotes for text (the variant that only appears at the top), but in the client's Word document there are typographic quotes (where the first is at the bottom).Often times a sequence of three dots is typed as an ellipsis, which should actually be entered as a special character (on the Mac with ALT + DOT) called "ellipsis".In many cases, a hyphen is used instead of a dash in a text - although a dash would belong.Every now and then I get texts from customers or authors who don't have a space after the comma or sometimes a space before the comma.Almost everyone has double or triple spaces in their texts.Some authors forget to add a space after the colon after a colon in a list.Would you like a few simple application examples? Here you are: And the cleaning itself can be designed freely or you can put together your desired "cleaning procedure" from existing routines. To put it simply, TextSoap is a text editor that offers a rich arsenal of functions that can be used to clean up texts. Today I am at SetApp stumbled across an exciting tool that could have helped me many times if only I had known: TextSoap from unmarked software. 5 Conclusion: A must if there is a lot of "foreign text".3 Very powerful: the ability to build cleansing functions yourself.2 Over 100 ready-made functions available.1 My previous solution: Search and replace via PHP script or in Pages.This tool works on Constant Values and Formulas will be skipped.Įxample (Deletion): Cell nthChars:’ver5’ X Nos. The nth character(s) is any given character or series of characters which will be searched and if found X number of character(s) which is specified by user, after nth Characters will be deleted or replaced. This tool is used to delete or replace X number of character(s) after nth character(S). This tool works on Constant Values and Formulas will be skipped.Įxample (Deletion): Cell nthChars:’ver5’ X Nos.:2 (Replace): Replace Text:’Data Cleaner’, X nos. The nth character(s) is any given character or series of characters which will be searched and if found X number of character(s) which is specified by user, before nth Characters will be deleted or replaced. This tool is used to delete or replace X number of character(s) before nth character(S). This tool works on Constant Values and Formulas will be skipped.Įxample (Deletion): Cell nthChars:’ver5’ result:’EDCver5’Įxample (Replace): Replace X nos. The nth character(s) is any given character or series of characters which will be searched and if found all trailing characters after nth chars of that cell will be deleted or replaced. This tool is used to delete or replace all text after nth character(S). This tool works on Constant Values and Formulas will be skipped.Įxample (Deletion): Cell nthChars:’ver5’ (Replace): Replace Text:’ExcelDataCleaner’, all text after nth Character(s): The nth character(s) is any given character or series of characters which will be searched and if found all leading characters before nth chars of that cell will be deleted or replaced. This tool is used to delete or replace all text before nth character(S). Remove/Replace all text before nth Character(s):
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |