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:
...
@@ -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)
-
Re
place double spaces
-
Re
move all whitespace (REGEX)
-
Re
move whitespace
-
Re
place 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