How to remove all character after first 8 digits in a column

Question

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 NO111111113111111111111114\11111111a.11111111B111111112

atcodedog05 · Accepted Answer

Hi @aishwarya_baburaj98

Here is how you can do it. You can use regex_replace or Left

Workflow:

OR

Hope this helps : )

Christina_H · Accepted Answer

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)

pdave87 · Accepted Answer

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