First time on this forum, hope someone can help
My question is as follows:
I have n number of strings
AZABCDEF, AZA78, AZAA24P, DEF1.....
I need to find a way to compare n number of strings and extract the common string value from the start of the strings.
So, using the above strings my returned value must be AZA