SOLVED
divide long sap order numbers with mess unknown dividers in between
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
lilyyangadsk
9 - Comet
11-09-2020
03:11 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I try to parse SAP order number original column as attachment to split 1,2,3,4..., but there are different SAP order numbers in between input by sales rep with ' or ; or and or space etc, can teach how to parse order number in such mess case? thank you
Solved! Go to Solution.
Labels:
- Labels:
- Custom Tools
7 REPLIES 7
21 - Polaris
11-09-2020
03:24 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@lilyyangadsk
Maybe this is what you want.
Appreciate if you could mark it as accept if you find it useful.
22 - Nova
11-09-2020
03:26 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Here is a workflow for the task.
Output:
Workflow:
Hope this helps 🙂
If this post helps you please mark it as solution. And give a like if you dont mind 😀👍
ACE Emeritus
11-09-2020
03:31 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
11-09-2020
06:04 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
thank you it works well for me. 😀
11-09-2020
06:06 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
thank you, I think this is also good ways.
22 - Nova
11-09-2020
06:07 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
11-09-2020
06:07 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
thank you, it works well and this is good ways, just a bit complex to me. 😅
