truncate part of import data

[Guest]

I'm importing a field that is delimited and has some ending alphanumeric
characters (usually 04 or 05 at the end of the cell). However they seemed to
be "spaced" and not "tabbed". How do I remove these alphanums from all of
the cells?

 

[Joseph Meehan]

I'm importing a field that is delimited and has some ending
alphanumeric characters (usually 04 or 05 at the end of the cell).
However they seemed to be "spaced" and not "tabbed". How do I remove
these alphanums from all of the cells?

How consistent is the data? Does each record have exactly the same
number of characters? Does each "field" have the same number of characters?
Is it always the last two characters of each record you want to eliminate?
Does each and every record have two characters you want to eliminate?

The best or even possible method depends on the details.

Assuming you want to eliminate the last two characters of each row -
record then using the import wizard advanced functions will allow you to
declare those last two characters as a separate field and not even import
it.