Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default Importing Data problem

I'm using Data Import to import a comma delimited file into Excel. In only
one record it's cutting off the text after a certain point and putting the
remainder in the next column. Other fields that contain more text than this
one are not being split. I checked for hidden characters that might be
causing something like this, but nothing. Any ideas?

Thanks.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 46
Default Importing Data problem

I've seen this happen in a text field when the field contains a
punctuation comma that the import perceives as a delimiter. If you
look at the raw file, does that string contain a comma?

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default Importing Data problem

There does happen to be a ", space" immediately before where the data splits
but there are hundreds of those all throughout the data and it doesn't happen
in those places.


"DaveO" wrote:

I've seen this happen in a text field when the field contains a
punctuation comma that the import perceives as a delimiter. If you
look at the raw file, does that string contain a comma?


  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8,651
Default Importing Data problem

It will tend not to split at a comma if this falls within a text field
enclosed in quotes, but will split otherwise. It gets more complicated if
the field also contains quotes, so if you save as a cvs Excel will double up
the quote marks in this situation.
--
David Biddulph

"Testing" wrote in message
...
There does happen to be a ", space" immediately before where the data
splits
but there are hundreds of those all throughout the data and it doesn't
happen
in those places.


"DaveO" wrote:

I've seen this happen in a text field when the field contains a
punctuation comma that the import perceives as a delimiter. If you
look at the raw file, does that string contain a comma?




  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default Importing Data problem - Resolved, sort of

Here's what was happening; all fields were already surrounded by double
quotes and separated by commas from the original export. Within that
particular field there was quoted text. I'm assuming that the end quotes of
that text interfered with the proper import. Removing the quotes around the
text allowed for successful import. Will figure out a way to determine actual
quoted text within the fields, substiute prior to data import then replace.

Thanks so much for the information that ultimately led to a resolution!

"David Biddulph" wrote:

It will tend not to split at a comma if this falls within a text field
enclosed in quotes, but will split otherwise. It gets more complicated if
the field also contains quotes, so if you save as a cvs Excel will double up
the quote marks in this situation.
--
David Biddulph

"Testing" wrote in message
...
There does happen to be a ", space" immediately before where the data
splits
but there are hundreds of those all throughout the data and it doesn't
happen
in those places.


"DaveO" wrote:

I've seen this happen in a text field when the field contains a
punctuation comma that the import perceives as a delimiter. If you
look at the raw file, does that string contain a comma?





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Problem Importing Fixed Width Data [email protected] New Users to Excel 7 September 15th 06 02:42 AM
Problem importing data into sql server database Me Excel Discussion (Misc queries) 1 January 27th 06 02:51 AM
Problem importing data from Access BT Connect Excel Discussion (Misc queries) 2 January 21st 06 05:07 PM
Problem importing external data Teresa Robinson New Users to Excel 0 October 13th 05 10:08 PM
Importing Data & Refresh Data Problem George Excel Discussion (Misc queries) 2 March 28th 05 01:37 AM


All times are GMT +1. The time now is 02:08 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"