fi大写的价值观ltered during import of Excel data [SOLVED]

jnick8855

Hi All,

Brand new here, I have tried to read proper etiquette for posting questions, this one should be a layup for someone I think. I have an excel column field that has a mixture of UPPER case values and lowercase values. Only the lower case values are making their way into my wordlist. Somehow all Uppercase values are getting filtered during the import or read process. A value like this,"Air Canada 455 Ottawa (ON) - Toronto Pearson (ON)" will be read by RM no problem but a value like this "VISA INFINITE PURCHASES]" will not get imported through the Read Excel process. Maybe I am missing a character setting or need a different operator. Any thoughts or links would be great.

Thanks,

JN

sgenzer

hmm that's weird. Have not seen that before. My first effort would be to go into "data set meta data information" (turn on "advanced parameters") and mandate that the column be brought in as polynominal. Also check that your encoding is correct (again an advanced parameter).

Scott

jnick8855

Thanks for the reply Scott. The encoding was incorrect...user error!

Cheers,

Jeff