Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

CSV Text importing as numbers

Status
Not open for further replies.
jyellis

jyellis

Instructor
Apr 22, 2006
4
US
CR10
My source data is a CSV file.

My field "object_id" has the following types of data in it.
1986.11
1970.23
1961.25
1961.224
P2000.62
P1999.13

How can I get CR to see the data as text. The "totext" command doesn't help, because it has already dropped the "p"

 
Sort by date Sort by votes
A CSV should have quotes around text objects, is a foile format issue.

You might be able to use a TOTEXT in a SQL expression though.

-k
 
Upvote 0 Downvote
SQL does not appear to have a TOTEXT command but a CONVERT command...do you have an example of this CONVERT command
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

dgillz
  • Locked
  • Question
Outlook as a Datasource?
Replies
0
Views
559
dgillz
dgillz
Ivan Kok
  • Locked
  • Question
Crystal Reports Runtime causing AS/400 DB2 Database ID to be disabled intermittently
Replies
0
Views
583
Ivan Kok
Ivan Kok
PeaEssEl
  • Locked
  • Question
ASP.Net Crystal Reports connection to SQL Server through published website
Replies
2
Views
143
PeaEssEl
PeaEssEl
AndersonCJA
  • Locked
  • Question
How to use a Synonym as a data source.
Replies
3
Views
192
AndersonCJA
AndersonCJA
LMGroup
  • Locked
  • Question
Need to get a value from a completely unrelated table to use as a constant
Replies
1
Views
81
kray4660
kray4660

Part and Inventory Search

Sponsor

Back
Top