F and T converted to True & False rather than strings

Hi,

I'm importing data where some of the fields contain F and T. After looking at it once it's read in some of the values, specifically Fs and Ts, have been converted to True and False.

Is there a recommend way of dealing with this? I've so far gone for selecting it and converting it to a string of size 1 which returns the truncation warning.

Is this the best method?

Many thanks,

Best Practices

Accepted answers

Thableaus

@josephhw

Yes, you'll definetely have some trouble if you're using the Text Input tool, it will automatically identify the field as a Boolean, and when you convert it back to a String, it sees it as False or True.

But the good thing is if you insert a space before or after your F/T string, it sees it as a string again. Then you could use either the Data Cleansing Tool or the Trim function to get rid of this whitespace.