PARSE DATA

[dunkindonut7777]

Hi All,

I want to know how to parse these characters. I only want to extract the first 6 digits, without touching the other value in column.

Sample:

Number	Expected Output
113302	113302
CCD08	CCD08
22 CCD INCD 05	22 CCD INCD 05
540013.1	540013
540321.19999999995	540321

I just want to extract the first 5 digits in a characters with period. Can you help me with this one?

[binuacs]

@dunkindonut7777 you want to parse the first 6 digits or 5 digits? You can adjust the below formula

[dunkindonut7777]

hello can you provide the alteryx file or the formula so that I can copy paste and edit?, 

[binuacs]

@dunkindonut7777 @I’m away from my system, I used your given input, just copy the given formula and try it should work

[caltang]

@binuacs I got you covered man.

@dunkindonut7777 please find binuacs' work here:

[caltang]

The formula is like this:

IIF(Length([Number]) < 6, 
[Number],
REGEX_Replace([Number], '(.{6}).*','$1'))

@dunkindonut7777 kindly mark binuacs' post as the solution. Thanks!