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

[aishwarya_baburaj98]

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

[Pravallika20]

hi @aishwarya_baburaj98 

can u pls share the sample input and output files

[atcodedog05 · Accepted solution]

Hi @aishwarya_baburaj98 

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

Workflow:

OR

Hope this helps : )

[Pravallika20]

Hi @aishwarya_baburaj98 ,

Hope this helps

[Christina_H · Accepted solution]

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 solution]

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

[pdave87]

@Christina_H marvelous 🙂 simple yet out of the box. Good one! thanks.