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.2K All Categories
- 67 General
- 11 Training
- 202 Installation / Setup
- 1.1K Flows
- 106 Rules
- 262 Administration
- 212 Portal
- 490 General Q & A
- 695 Forms
- 333 Reports
- 3 Designer Extensions
- 47 Example Flows
- 52 CSS Examples
- 1 Diagram Tile
- 7 Javascript Controls
- 179 Pages
- 5 Process Mining
- New Features
- 179 Datastructures
- 69 Repository
- 221 Integrations
- 28 Multi-Tenant
- 27 SDK
- 78 Modules
- 56 Settings
- 25 Active Directory
- 12 Version 7
- 35 Version 8
- 83 Lunch And Learn Questions