Q) CITY column of a table contains information such as Bangalore , Bangalore-64 , Bangalore-56001 , Mumbai - 400002 etc in order to have just city information in the column following will need to be done
A. Data Merging
B. Data Splitting
C. Data Parsing
D. Data Mapping