Skip to content
GitLab
Menu
Why GitLab
Pricing
Contact Sales
Explore
Why GitLab
Pricing
Contact Sales
Explore
Sign in
Get free trial
Changes
Page history
Update Analyse "Modify String Values"
authored
Apr 28, 2021
by
Samuel Melm
Show whitespace changes
Inline
Side-by-side
Analyse-"Modify-String-Values".md
View page @
9e936ff8
...
...
@@ -8,14 +8,14 @@ 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)
-
Re
place double spaces
-
Re
move whitespace
-
Remove symbols
-
Remove accents
-
Break out CamelCase
(REGEX)
-
Remove first/last word(s)
(REGEX)
-
Re
move all whitespace (REGEX)
-
Re
place double spaces (REGEX)
-
Remove symbols
(REGEX)
-
Remove accents
(REGEX)
-
Remove a specific sub-string (all or first)
-
Trim quotes
-
Trim quotes
(REGEX)
-
Pad Values
-
Add prefix or suffix to strings
-
Standardize String Values
...
...
@@ -28,11 +28,12 @@ Trifacta lists the following sub-scenarios:
Excluded from this analysis:
-
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
## Atomic operations
-
-
Note: text in bold tries to suggest "atomic operation"
-
Fill out
\ No newline at end of file