Hello,
Try trimming out the spaces (
rtrim
/
ltrim
)and replacing (the dot) the imported into a newer table.
See sample syntax below;
- import into a temp table; table 1
- clean (with trim and replace) and write to a new table with
distict
keyword to remove duplicates occurring.
select distinct replace(rtrim(ltrim(var1)),'.',''), other columns INTO Permanent_Table From Table 1
Hope this helps, good luck.
Ali J