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

Question

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&nbsp; format.I need to create new column for the extracted code.Would you be able to help me.Thanks in advance

thennarasu_r · Answer

Hi&nbsp;AJAyr&nbsp;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&nbsp; side first 7 digits you should use Right Function.Thanks,Thennarasu

ajayr · Answer

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

uzi2019 · Answer

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

anonymous · Answer

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

Forum Discussion

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

4 Replies

Related content

Extracting complicated text from a column

New Column

Extract 2 digits from a column

Grouping rows by Column and then updating Column

Extract Cetrain Characters from Text Column