I hope you can help me. I need to create a calculated column to identyfy the lines with a 6 digit number in the text.
Is there a function to identify the notifictn(unic number) that has a 6 digit number in the material text(placed at different positions and with different 6 digit numbers)?
Please test the following. I did not have the chance to test from my side.
6 digit number = VAR String = 'Table'[Material Description] VAR Items = SUBSTITUTE ( String, " ", "|" ) VAR Length1 = COALESCE ( PATHLENGTH ( Items ), 1 ) VAR T1 = GENERATESERIES ( 1, Length1, 1 ) VAR T2 = SELECTCOLUMNS ( T1, "@Item1", PATHITEM ( Items, [Value] ) ) VAR T3 = FILTER ( T2, VAR Item1 = COALESCE ( [@Item1], 1 ) VAR Length2 = LEN ( Item1 ) VAR T4 = GENERATESERIES ( 1, Length2, 1 ) VAR T5 = SELECTCOLUMNS ( T4, "@Item2", MID ( Item1, 1, [Value] ) ) VAR T6 = GENERATESERIES ( 0, 10, 1 ) RETURN LEN ( Item1 ) = 6 && ISEMPTY ( EXCEPT ( T5, T6 ) ) ) RETURN MAXX ( T3, [@Item] )
Hi @tamerj1 I really apprecialte your help. Thank you.
I cannot make it Work. I think that I need to change what is marked by ned in below scrren dump, however, I am not certain what I need to change it to.
Apologies again. It should be [@Item1]