SOLVED
Leading and Trailing Whitespace
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
beacc
7 - Meteor
‎03-28-2023
04:58 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi everyone,
I don't know if is possible, but I have a workflow where I don't want to use the Data Cleansing tool, because is taking too much time.
Is it possible to clean Leading and Tariling Whitesapce's with the RegEx tool, I have already tryied but I can't get there.
The main objective is to clean the spaces between the "|", before the text to columns tool.
Thank you all
Solved! Go to Solution.
Labels:
- Labels:
- Custom Tools
5 REPLIES 5
15 - Aurora
‎03-28-2023
05:26 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
18 - Pollux
‎03-28-2023
05:38 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
peterr_h
8 - Asteroid
‎03-28-2023
05:42 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
This is the approach that I'd have suggested too. Looks good!
‎03-28-2023
05:45 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you all
txjohnnypops79
8 - Asteroid
‎04-26-2023
07:04 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
