OpenText

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,
OpenText seems to always drop trailing zeros off of decimal numbers when
opening a text file.

My text file has decimal numbers that represent two dimensional sequetial
numbering, so 1.1 thru 1.10 will result in (2) 1.1's and no 1.10's
Is there a way to preserve the number in text format when using OpenText?
 
You have to import the fields in question as text. The data type argument
in the FieldInfo for each such field must be a 2, e.g. Array(1, 2), as you
can see by looking at help for the OpenText method.

--
Jim
| Hello,
| OpenText seems to always drop trailing zeros off of decimal numbers when
| opening a text file.
|
| My text file has decimal numbers that represent two dimensional sequetial
| numbering, so 1.1 thru 1.10 will result in (2) 1.1's and no 1.10's
| Is there a way to preserve the number in text format when using OpenText?
| --
| Thanks,
| Mike
 

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

opentext command 1
Import decimal numbers with trailing zeros into Excel 1
COUNTIF() data type problems 3
no decimal point if zero 19
Find & Replace Macro 3
importing undelimited text file data, character-by-character 4
VBA opentext command 5
OpenText runtime error '1004' 2

Back
Top