SOLVED
Opposite of LEFT function
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
soncoku
9 - Comet
‎10-27-2020
06:01 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi all.
I have a column which has data like the row below:
not in the system - A Random Client Name
What I'm trying to do is to is to use a function that will skip an x number of characters.
Like LEFT function
LEFT ([Field1], 20) ==> Gets first 20 characters. I need something that skips the first 20 characters.
Any ideas?
Solved! Go to Solution.
Labels:
- Labels:
- Workflow
3 REPLIES 3
17 - Castor
‎10-27-2020
06:03 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @soncoku,
I think you are looking for substring!
Substring(String,start,length)
Please mark as soled if this was helpful!
echuong1
Alteryx Alumni (Retired)
‎10-27-2020
06:10 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
20 - Arcturus
‎10-27-2020
06:14 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
