Skip to content
Update Analyse "Modify String Values" authored by Samuel Melm's avatar Samuel Melm
...@@ -8,14 +8,14 @@ Trifacta lists the following sub-scenarios: ...@@ -8,14 +8,14 @@ Trifacta lists the following sub-scenarios:
- Clean Strings - Clean Strings
- Trim strings: remove whitespaces (and tabs) from the front and back of the string - 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 - Define and enforce formats (e.g. url/zip code) and replace wrong values with defaults
- Break out CamelCase - Break out CamelCase (REGEX)
- Remove first/last word(s) - Remove first/last word(s) (REGEX)
- Replace double spaces - Remove all whitespace (REGEX)
- Remove whitespace - Replace double spaces (REGEX)
- Remove symbols - Remove symbols (REGEX)
- Remove accents - Remove accents (REGEX)
- Remove a specific sub-string (all or first) - Remove a specific sub-string (all or first)
- Trim quotes - Trim quotes (REGEX)
- Pad Values - Pad Values
- Add prefix or suffix to strings - Add prefix or suffix to strings
- Standardize String Values - Standardize String Values
...@@ -28,11 +28,12 @@ Trifacta lists the following sub-scenarios: ...@@ -28,11 +28,12 @@ Trifacta lists the following sub-scenarios:
Excluded from this analysis: Excluded from this analysis:
- Convert colums to one string column (aka printf), because it does not modify strings. - Convert colums to one string column (aka printf), because it does not modify strings.
## Scenario and user-visible elements
## Scenario and user-visible elements
- Fill out - Fill out
## Atomic operations ## Atomic operations
-
- Note: text in bold tries to suggest "atomic operation" - Note: text in bold tries to suggest "atomic operation"
- Fill out - Fill out
\ No newline at end of file