Analyse-"Modify-String-Values".md

@@ -6,16 +6,18 @@ Modify string includes all scenarios that are applied to a string column and tra
 Trifacta lists the following sub-scenarios:
 
 - Clean Strings
-    - Trim strings: remove whitespaces (and tabs) from the front and back of the string
+
     - Define and enforce formats (e.g. url/zip code) and replace wrong values with defaults
     - Break out CamelCase
-    - Remove first/last word(s)
-    - Remove all whitespace
-    - Replace double spaces
-    - Remove symbols
-    - Remove accents
-    - Remove a specific sub-string (all or first) 
-    - Trim quotes
+    - Remove from string:
+        - leading/trainling whitespaces (and tabs) (aka trim)
+        - first/last word(s)
+        - all whitespace in string
+        - double spaces (replace by single spaces)
+        - symbols (everything but letters and numbers) especially includes punctuation
+        - special letters (e.g. transform ä to a)
+        - a specific sub-string (all or first occurence) 
+        - quotes arround the string
 - Pad Values
     - Add prefix or suffix to strings
 - Standardize String Values
@@ -33,7 +35,7 @@ Excluded from this analysis:
 - Fill out
 
 ## Atomic operations
-- 
+- nearly all of these scenarios can be covert by a regex engine
 
 - Note: text in bold tries to suggest "atomic operation"
 - Fill out
\ No newline at end of file