number to string

atse · Oct 5, 2003

Hi,

When I select a filed from a txt or csv file, and display on the ASP, the 16
digit of barcode number (9876543210123456) becomes to 9.87654321012345E+15.
How can I make it display the original. Thanks

Atse

Ray at · Oct 5, 2003

How are you "selecting" it and "displaying" it?

Ray at home

atse · Oct 6, 2003

the source code
<%
' pass the filename of a file located in C:\upload\
file=Request.QueryString("file")

con_xls="Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=C:\upload\\test.xls;Extended
Properties=""Excel 8.0;HDR=Yes;IMEX=1"""
set conn=server.CreateObject("ADODB.Connection")
conn.open(con_xls)

set rs = conn.execute ("select * from " & file)

%>
<HTML>
<HEAD>
<META NAME="GENERATOR" Content="Microsoft Visual Studio 6.0">
</HEAD>
<BODY>
<table border=1>
<%
if not rs.eof then
%>
<% do until rs.EOF %>
<tr>
<%
' there are 16 columns in this file, but I don't know how to define a
variable of the number of columns

for i =0 to 15
%>
<td> <%= rs(i)%> </td>
<%next%>
</tr>
<% rs.MoveNext
loop

end if
%>
</table>
</BODY>
</HTML>

Ray at · Oct 6, 2003

It seems to me that the only way that you can get this to display directly
from the RS the way you want is if you format the cell in Excel to display
the number as text.

Ray at home

atse · Oct 6, 2003

I am now trying insert the csv file into the database, and I set this field
as VARCHAR with length = 50
but 9876543210123456 in the original file still displays
9.87654321012345E+15 in the database, ASP,and the exported csv file.
Any idea to solve this problem

atse

Ray at · Oct 6, 2003

What does it look like in the CSV file when you look at it in a text editor,
such as notepad?

Ray at home

atse · Oct 6, 2003

The original one in Notepad is OK: 9876543210123456
after inserted into the database, it looks like 9.87654321012345E+15 (I can
view the record of database)

The exported csv file in Notepad and Excel looks like 9.87654321012345E+15

Mark Schupp · Oct 6, 2003

I came in late on this thread. What tool are you using to import the
original CSV?

If you are opening it with the MS Text drivers as a database you will need
to include a column definition INI file to tell the drivers that the column
is character data and not numeric (it should also be enclosed in quotes in
the CSV file). Unfortunately I cannot remember the name that the INI file
must use. Search through the documentation at Microsoft for the text
drivers.

atse · Oct 7, 2003

' The text driver is:
con_csv="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\mypath\;Extended
Properties=""text;HDR=No;FMT=Delimited"""
set conn=server.CreateObject("ADODB.Connection")
conn.open(con_csv)

' Because this is a csv file, I can only make a query string:
set Rs=conn.execute("select * from thisfile.csv")

' Then I run a script to insert these records into the database.
Unfortunately when this long number is inserted into the database, it
changes to another format as text. How can I make this long number as text
when inserting into the db? Thanks

Atse

Mark Schupp · Oct 7, 2003

There is a specially formatted INI file that you need to include in the same
directory as the CSV file to tell the Jet text driver that the column in
question is String instead of numeric. By default, the text driver "guesses"
the data type based on the "typical" contents of the column. I cannot
remember the name of the INI file but you should be able to find it in the
Microsoft documentation for the desktop drivers (I have to search for it
every time the subject comes up because I can never remember it).

atse · Oct 7, 2003

Yes, I agree that, but I don't get the driver either

New to VHDL... Trying to convert a 2-bytes number into an decimal	0	Dec 9, 2022
How to get day (number), month (number) and year from a date using month's french name?	3	Feb 5, 2023
Sort by number of characters	1	Nov 2, 2023
I need help with my python assignment and I'm stuck can't find any solution for it. Convert CSV string format to JSON format	0	Oct 12, 2021
How to fix ssl.SSLError: [SSL: WRONG_VERSION_NUMBER] wrong version number (_ssl.c:2570)	0	Jul 28, 2023
I would like to use awk to calculate the total number of records processed	1	Aug 25, 2022
How to read from a .csv file in Java?	1	Nov 6, 2023
I want to code whatsapp phone number validator. The script will	1	Feb 20, 2023

number to string

atse

Ray at

atse

Ray at

atse

Ray at

atse

Mark Schupp

atse

Mark Schupp

atse

Ask a Question

Similar Threads

Members online

Forum statistics

Latest Threads