Analyse-"Modify-String-Values".md

@@ -5,6 +5,11 @@ Modify string includes all scenarios that are applied to a string column and tra
 
 Trifacta lists the following sub-scenarios:
 
+- Basic String Operations
+   - Prepend/Append to string ("foo" + "bar" -> "foobar")
+   - Substring (e.g. "Hello World"[1,4] -> "ello")
+   - Replace substring with other string
+   - Others that don't qualify as "modify string" (length, isSubstring, indexOf...)
 - Clean Strings
     - Define and enforce formats (e.g. url/zip code) and replace wrong values with defaults
     - Remove from string:
@@ -16,18 +21,13 @@ Trifacta lists the following sub-scenarios:
         - 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
-    - Standardize case
-    - Break out CamelCase
+    - Standardize case: toLower, toUpper
+    - Break out CamelCase ("fooBar" -> "foo bar")
     - Standardize String Lengths
-    - Pad string values
-    - Fix the length of strings 
-- Sub-Strings
-    - length
-    - find/rightfind
-    - splicing/substring
+        - Pad string values (e.g. leading/trailing spaces)
+        - Fix the length of strings (e.g. remove all characters after the 8th)
 
 Excluded from this analysis:
 - Convert colums to one string column (aka printf), because it does not modify strings.