extract 6-7 digit code from a column into a new column

[AJAyr]

Hi all,
I am needing help to extract 6-7 alphanumeric digit code from a column where there are multiple codes in a row without any specific  format.I need to create new column for the extracted code.Would you be able to help me.

Thanks in advance

[Thennarasu_R]

Hi @AJAyr 

You could use this Dax .

Column =Left(Column Name , 7)
If you want left side first 7 digits you should use Left Function.
Column = Right (Column Name , 7)
If you want Right  side first 7 digits you should use Right Function.

Thanks,
Thennarasu

[AJAyr]

Thank you. But, I need to extract 4 different 7 digit unique codes to a new column

[Uzi2019]

Hi @AJAyr 
Can you share the data sample with required output? We'll get better understanding by looking at input and output

[Anonymous]

Hi, this is an example of my output.The output varies but different rows it's a string with alphabets and number and it can be 6 or 7 digits.varies in different rows.Hope it helps