Parsing a number
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I need to separate the number 205123456789999911 into 3 parts, according to the principle of the first 3 characters, then the next 13, then the last 2, but I encounter a problem when this part of 13 characters has less than 13 because it is entered by the end user,my workflow later adds a 0 in front of the middle number to get 13 characters, any advice is welcome
I know that I extract the first 3 and the last 2 characters using the left and right formula, but I don't have a solution for this in the middle
Solved! Go to Solution.
- Labels:
- Apps
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
My input is 205-1234567899999-11 after that I use the data cleaning tool to make it 205123456789999911 and connect it to regex as you put it but I don't get the result
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@Aleksandar1 If the middle number less than 13 you want to left pad with 0's?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I already did that later in workflow,but my problem is parsing when middle number has less than 13 characters
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I know about that with text to columns,but problem is when end user enter number without - or white space like this 205123456789999911 and middle number has less than 13 characters
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
