Replace dots with space using Replace
I have a field which has 008.2009.
I need to extract the contents before DOT character or just ignore the contents after DOT character.
Used replace string function but just replaces the DOT character with space.
Without UDF, let me know whether it is possible using std functions.