What I want exactly is, a new field is created automatically and if there are any leading and trailing white spaces in the attribute, just put 0s and 1s in that newly created field. Can we do that in FME?
Thank you in advance !
Flag the White Spaces
I have an attribute "Address" from which I want to flag (and not trim) the left and right (Leading & Trailing) white spaces.
Userlevel 2
+17
- Contributor
- 7538 replies
-
17 February 2014
Hi,
I would use an AttributeCreater with a Conditional Value setting.
-----
Flag =
If @Value(Address) Begins With <space> AND @Value(Address) Ends With <space> Then <flag for both>
Else If @Value(Address) Begins With <space> Then <flag for left>
Else If @Value(Address) Ends With <space> Then <flag for right>
Else <flag for no spaces>
-----
Replace <space> with a real white space when setting.
"Matches Regex" operator and appropriate regular expressions can be also used.
Takashi
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.