How to remove all character after first 8 digits in a column
- 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
Hi All,
If below is an example for invoice# column, I want to remove any characters (this could be letters, special characters, and/or numbers). How can I remove the additional characters after first 8 numbers? Inputs and outputs are in excel formats
INVOICE NO |
11111111 |
31111111 |
11111114\ |
11111111a. |
11111111B |
111111112 |
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
can u pls share the sample input and output files
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Here is how you can do it. You can use regex_replace or Left
Workflow:
OR
Hope this helps : )
- 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
A couple of easy options would be to change the field length to 8 with a Select tool, or use a formula: Left([INVOICE NO],8)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi,
There are many ways to parse data and in this use case I will suggest use functions - Left or Right to divide the data as required. Please refer below screen-print as solution. Refer rows from 3 to 6, hope this answers your question.
Regards,
Pratik
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@Christina_H marvelous 🙂 simple yet out of the box. Good one! thanks.