Problem importing text field, leaving out those starting with lett

S

sueshe

I am importing a Fixed Length Text file, which imports ok, however it is not
pulling in all items of one field. The field is a patient number field which
contains mostly numbers, but there are some patient numbers that begin with
letters. These are the ones it is leaving out. I have tried importing it as
text but still will not bring those patient numbers in. Any suggestions?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Page numbering with Merged Document and IF statements 1
Import Word form, error related to number field blank 0
Display bug in Word: tables disappearing on copy and paste of text with bullet points into table 2
Type Conversion Failure importing number as text 1
Importing text into number field- Error 4
Importing an Excel File 1
Error Saving Import/Export Spec 1
Cannot sort a table containing text 5

Top