I’ve an Excel with 2 Columns and multiple rows.
United States of America
New York NY
New Zealand NZ
Conditions are as follows:
- If the “Name” whose character length exceeds more than 5, it should have abbreviation; if not than the whole row should be cut off and added to exception results.
- If the “Name” has the abbreviation than no problem at all.
Final output should a single DataTable containing only “Name” column.
Thanks in advance…