SOLVED
Removing characters based on FIND
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
jb
7 - Meteor
‎05-26-2016
04:12 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi,
Can anyone tell me what the Alteryx formula equivalent should be for this excel statement?
=LEFT(J3,(FIND(":L",J3,1))-1)
The "J3" cell in this case is a column called "Ad Name" and we are trying to convert a value like this:
Sample|FY16|Sample|CPM|1x1|RON|CRM|EE75+||PC|V|SSIC|P|Deal ID_:15_EE No Kids:L13686562_04/29
to be shortened based on where it finds ":L" to be:
Hotwire|FY16|Turn|CPM|1x1|RON|CRM|EE75+||PC|V|SSIC|P|Deal ID_:15_EE No Kids
Thanks!
Solved! Go to Solution.
Labels:
- Labels:
- Preparation
1 REPLY 1
JohnJPS
15 - Aurora
‎05-26-2016
04:33 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Does this work:
Left([Ad Name],FindString([Ad Name],":L")-1)