Needing to strip off trailing spaces
Comments
-
Good afternoon,
I am working on a file where I need to match up data from two different sources. I am running into a problem where I am unable to get a match due to trailing spaces on one data source.
I am looking for a step that will strip off trailing spaces. I have tried each of the following steps and none of them seem to do what I am looking for:
[ul][li]Strip Characters[/li][li]Strip Non Ascii Characters From String[/li][li]Strip Quotation From CSV[/li][li]Strip Special Characters (Newline)[/li][/ul]Is there a function that will work for my use case? Here are two sample fields that I need to have spaces stripped from:
[table][tr][td]THE POOL EXPERTS INC [td]PO BOX 65 [/table]If there is something available in the documentation, please let me know.
-
[font=Roboto, Arial, Helvetica, sans-serif]The Trim String step under Data > Text in the step toolbox can be leveraged to remove preceding and trailing invisible characters from a string.[/font]
Howdy, Stranger!
Categories
- 4.4K All Categories
- 82 General
- 13 Training
- 210 Installation / Setup
- 1.2K Flows
- 110 Rules
- 270 Administration
- 213 Portal
- 498 General Q & A
- 714 Forms
- 347 Reports
- 3 Designer Extensions
- 48 Example Flows
- 58 CSS Examples
- 1 Diagram Tile
- 8 Javascript Controls
- 187 Pages
- 5 Process Mining
- New Features
- 186 Datastructures
- 70 Repository
- 230 Integrations
- 29 Multi-Tenant
- 27 SDK
- 81 Modules
- 59 Settings
- 26 Active Directory
- 12 Version 7
- 35 Version 8
- 143 Lunch And Learn Questions