By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,116 Members | 1,319 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,116 IT Pros & Developers. It's quick & easy.

schema info file

P: n/a
hello everyone,

how do i specify a decimal position for a certain field in my schema file?

(for example:
Col1="AMT" Double Width 10
)
the amount field in the data file does not contain a decimal (i guess it's
assumed).

when i try to import using text provider there is no decimal point. is there
a way i can get that to work?
Nov 21 '05 #1
Share this Question
Share on Google+
6 Replies


P: n/a
Mattie,

Maybe I should know this, however what kind of schema?

Cor

"mattie" <ma****@discussions.microsoft.com>
hello everyone,

how do i specify a decimal position for a certain field in my schema file?

(for example:
Col1="AMT" Double Width 10
)
the amount field in the data file does not contain a decimal (i guess it's
assumed).

when i try to import using text provider there is no decimal point. is
there
a way i can get that to work?

Nov 21 '05 #2

P: n/a
On Tue, 21 Dec 2004 12:49:06 -0800, mattie <ma****@discussions.microsoft.com> wrote:

hello everyone,

how do i specify a decimal position for a certain field in my schema file?

(for example:
Col1="AMT" Double Width 10
)
the amount field in the data file does not contain a decimal (i guess it's
assumed).

when i try to import using text provider there is no decimal point. is there
a way i can get that to work?

See the following:

http://msdn.microsoft.com/library/de...a_ini_file.asp
Paul ~~~ pc******@ameritech.net
Microsoft MVP (Visual Basic)
Nov 21 '05 #3

P: n/a
this is the exact article i'm reviewing: my question is
under the topic Specifying Data Type Formats and Conversions
how do you specify those options?
"Paul Clement" wrote:
On Tue, 21 Dec 2004 12:49:06 -0800, mattie <ma****@discussions.microsoft.com> wrote:

¤ hello everyone,
¤
¤ how do i specify a decimal position for a certain field in my schema file?
¤
¤ (for example:
¤ Col1="AMT" Double Width 10
¤ )
¤ the amount field in the data file does not contain a decimal (i guess it's
¤ assumed).
¤
¤ when i try to import using text provider there is no decimal point. is there
¤ a way i can get that to work?

See the following:

http://msdn.microsoft.com/library/de...a_ini_file.asp
Paul ~~~ pc******@ameritech.net
Microsoft MVP (Visual Basic)

Nov 21 '05 #4

P: n/a

"mattie" <ma****@discussions.microsoft.com> wrote in message
news:21**********************************@microsof t.com...
hello everyone,

how do i specify a decimal position for a certain field in my schema file?

(for example:
Col1="AMT" Double Width 10
)
the amount field in the data file does not contain a decimal (i guess it's
assumed).
Not by the schema.
Your assumption is incorrect.
There can be no assumed or implied decimal point using this method.
when i try to import using text provider there is no decimal point. is
there
a way i can get that to work?


The data file must have a point in numeric fields, or whatever character you
specify using DecimalSymbol
You need to go back to whatever generated the text file and change the
process so it puts decimal places in.
Or, if the decimal place is defiinitely implied to (say) 2 places then
import to a table and then divide by 100.

If you're from one of those countries uses commas for decimal points then
you'll also want to consider fixed width fields as comma delimited will be a
bit of a problem.

--
Regards,
Andy O'Neill
Nov 21 '05 #5

P: n/a
On Wed, 22 Dec 2004 12:07:02 -0800, "rodchar" <ro*****@discussions.microsoft.com> wrote:

this is the exact article i'm reviewing: my question is
under the topic Specifying Data Type Formats and Conversions
how do you specify those options?

What is the format of the text for this particular value in the file? In other words, in what
position of the value does the decimal position appear?
Paul ~~~ pc******@ameritech.net
Microsoft MVP (Visual Basic)
Nov 21 '05 #6

P: n/a
thanks this helped.

"Andy O'Neill" wrote:

"mattie" <ma****@discussions.microsoft.com> wrote in message
news:21**********************************@microsof t.com...
hello everyone,

how do i specify a decimal position for a certain field in my schema file?

(for example:
Col1="AMT" Double Width 10
)
the amount field in the data file does not contain a decimal (i guess it's
assumed).


Not by the schema.
Your assumption is incorrect.
There can be no assumed or implied decimal point using this method.
when i try to import using text provider there is no decimal point. is
there
a way i can get that to work?


The data file must have a point in numeric fields, or whatever character you
specify using DecimalSymbol
You need to go back to whatever generated the text file and change the
process so it puts decimal places in.
Or, if the decimal place is defiinitely implied to (say) 2 places then
import to a table and then divide by 100.

If you're from one of those countries uses commas for decimal points then
you'll also want to consider fixed width fields as comma delimited will be a
bit of a problem.

--
Regards,
Andy O'Neill

Nov 21 '05 #7

This discussion thread is closed

Replies have been disabled for this discussion.