Dear all,
I have the below query. In a column called Sizes S – I have the below sizes. I would like to take the last one A58, but when I apply the below Right/InStr - I get not only the the comma deleted but also the first capital A. Can anybody help or provide another query that does the same?
54,46,50,58,A46,A48,A50,A52,A54,A56,A58
Last Size: (Right([Sizes S],InStr(1,[Sizes S],",")-1))
Thanks in advance
I have the below query. In a column called Sizes S – I have the below sizes. I would like to take the last one A58, but when I apply the below Right/InStr - I get not only the the comma deleted but also the first capital A. Can anybody help or provide another query that does the same?
54,46,50,58,A46,A48,A50,A52,A54,A56,A58
Last Size: (Right([Sizes S],InStr(1,[Sizes S],",")-1))
Thanks in advance