Trying to strip the "X's" from the part number once it has been imported
into our database would be very time consuming.

If you are doing this import just once, or with a very low frequency, you
can choose a strange character instead of the 'X', open the csv file with
notepad/wordpad, and replace all that initial character with the
edit-replace option.