TRIMMING AND RETAINING DIGITS

[laaperex]

how to make this consistent with only 8 digits? tried everything from trim to substring to padleft and right. really need it asap :( it will make duplicates everytime i trim and retain.

11105202
11106000
11106002
12150001
41412003
41412005
41412006
41412803
5151550000
5151550001
5151550002
5151551500
5151552000
5151552002
5151552007
5160600000
5160600001
71830000
71850000

[laaperex]

JUST LIKE THIS....

6151551303 Janitorial & Cleaning Supplies/Materials 1385781.72         51551303

6851551303 Material Issues - Consumable 126588.98                           51551303

the bold numbers are generated from doing padleft and subtring that causes duplicates. 

[ShankerV]

Hi @laaperex 

I hope I understood your requirement correctly. 

Please find the solution below.

Many thanks

Shanker V

[laaperex]

hi. i did that before. however, it'll create duplicates. 

[ShankerV]

Step 1: Input 

Step 2: As the data's are in numbers Alteryx will directly consider as Double 

Use Select tool to convert to String

Step 3: Use Regex tool to get your output

Let me know if there's anything above I can clarify for you further. 

[ShankerV]

From the output column, I have shared. Use the Unique tool to remove the duplicates.

That will resolve the issue.

[ShankerV]

@laaperex 

Hope your issue is resolved.

If not let me know how your expected output should be, so can work on it.

Shanker V

[laaperex]

yes2 but they have different amounts. so i could not retain unique codes only :(

[ShankerV]

@laaperex 

Sorry your output expectation is not clear, 

Can you explain it clearly. What is your expected output.

Shanker V

[laaperex]

i should remove those in red to create an 8 digit account number same with other accounts. however, the first 2 digits were removed