Guys, I need to pull the district from postcode, so it would be various length string, from 2 to 4, but basically all up to first space.
How can I achieve this?
I know how to cut out last 3 characters using right function, but how to cut left side up to first space?
How can I achieve this?
I know how to cut out last 3 characters using right function, but how to cut left side up to first space?