SOLVED
How to use SUBSTITUTE in Alteryx
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
Peter15653111
5 - Atom
‎08-15-2023
12:38 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi,
how to use substitute in Alteryx?
below formula I used in excel, how can I use Alteryx to achieve instance_num function.
SUBSTITUTE(Text, old_text, new_ text, instance_num)
For example, I want to replace the second "A" with "B" in ID NUMBER, the correct ID NUMBER should display as below.
ID NUMBER Correct ID NUMBER
AA213DFSF --- AB213DFSF
AAAASSDD --- ABAASSDD
213ABBBA --- 213ABBBB
Solved! Go to Solution.
Labels:
- Labels:
- Preparation
3 REPLIES 3
ShankerV
17 - Castor
‎08-15-2023
12:52 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Please use the below 2 tools.
1. Text to Columns tool
2. Then Formula tool to join back.
Many thanks
Shanker V
ShankerV
17 - Castor
‎08-15-2023
01:04 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Please find the use case explained.
 
Step 1: Input
 
Step 2:
 
Step 3:
 
 
Step 4:
 
Many thanks
Shanker V
‎08-15-2023
02:19 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you Shanker
