Forum Discussion
extract 6-7 digit code from a column into a new column
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...
Thennarasu_R
Responsive Resident
Responsive ResidentHi 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
Thank you. But, I need to extract 4 different 7 digit unique codes to a new column
Uzi2019Community Champion
Hi AJAyr
Can you share the data sample with required output? We'll get better understanding by looking at input and output
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