Forum Discussion
New column based on occurrence of string from another column
Hi all, I would like to create a new column in a table that will show me Master Document numbers for Project Copies. Example: Table "Document" Document Number Document Category 61-2...
Einomi
Helper V
Helper VHi,
Did you try to extract the 14 first characters of the column Document Number, maybe it can be faster
You go to the ribbon
Add column > Extract > First characters and then type in 14
Yes I tried, but this will not work for all cases, because the lenght of Master Documents can be different and we need to check it by Category.