I have a view that pulls in a field, the feild has data in the following format.
A1-an987389
B21-At081l0
AA1-ath01882
how would i get the infoamtion before the "-" IE
A1
B21
AA1
the size of the data before the "-" can be anything from 1 up 5 charcters
i dont think this can be done, but if it could it could same me a weeks worth of work
thanks in advanced.
Mike