Data string ends up in first cell instead of Comma sepaerated CSV format

  • Thread starter Thread starter Katherine
  • Start date Start date
K

Katherine

I have a java application that uses toCSV method for
taking a string and putting it in a csv format file. What
happens is I see most of the data go into first cell of
the spreadsheet instead of comma delimited style.

This is what it looks like in A1



AFFILIATE_ID,ASU_ID,FIRST_NAME,MIDDLE_NAME,LAST_NAME,CURREN
TLY_ENROLLED_FLAG,SEMESTER,COLLEGE_CAMPUS_CODE,COLLEGE_OR_D
IVISION_CODE,COLLEGE_DESCRIPTION,DEGREE_CODE,DEGREE_DESCRIP
TION,MAJOR_CODE,MAJOR_DESCRIPTION,DARS_MINOR_1,DARS_MINOR_2
,DARS_MINOR_3,DARS_CONCENTRATION_1,DARS_CONCENTRATION_2,DAR
S_CONCENTRATION_3,DARS_CERTIFICATE_1,DARS_CERTIFICATE_2,DAR
S_CERTIFICATE_3,ACADEMIC_LEVEL_CODE,ACADEMIC_LEVEL_DESCRIPT
ION,ARIZONA_RESIDENCY_DESCRIPTION,CONDITIONAL_ADMIT_FLAG,CO
NDITIONAL_ADMIT_REASON_DESC,HIGH_SCHOOL_DEFICIENCY_FLAG,HIG
H_SCHOOL_ENGLISH_DEFICIENCY,HIGH_SCHOOL_ARTS_DEFICIENCY,HIG
H_SCHOOL_LANGUAGE_DEFICIENCY,HIGH_SCHOOL_MATH_DEFICIENCY,HI
GH_SCHOOL_LAB_SCIENCE_DEFICIENCY,HIGH_SCHOOL_SOCIAL_SCIENCE
_DEFICIENCY,HIGH_SCHOOL_NAME,HIGH_SCHOOL_STATE_DESCRIPTION,
HIGH_SCHOOL_CLASS_RANK_PERCENT,HIGH_SCHOOL_GPA,ABOR_HS_GPA,
ACT_COMPOSITE_EXAM_SCORE,SAT_COMBINED_EXAM_SCORE,ENROLLED_H
OURS,CHANGED_MAJOR_FLAG,CENSUS_MAJOR_CODE,CENSUS_MAJOR_DESC
RIPTION,LIVING_ON_CAMPUS_FLAG,RESIDENCE_HALL_NAME,RESIDENCE
_HALL_WING,RESIDENCE_HALL_FLOOR,DIRECTORY_RELEASE_CODE,DIRE
CTORY_RELEASE_DESCRIPTION,LOCAL_LINE_1,LOCAL_LINE_2,LOCAL_C
ITY,LOCAL_STATE_CODE,LOCAL_ZIP_CODE,LOCAL_PHONE_NUMBER,EMAI
L_ADDRESS,ASU_EMPLOYEE_FLAG,ASU_JOB_TITLE,ASU_TOTAL_FTE_PER
CENTAGE,ASU_HR_DEPARTMENT_NAME,ADVISOR_LAST_NAME,ADVISOR_FI
RST_NAME,ADVISOR_EMAIL_ADDRESS,ADVISOR_EMPLOYEE_PHONE,BELOW
_2_GPA_FLAG,CUMULATIVE_GPA,LOW_MID_TERM_GRADE_FLAG,TAKING_G
ATEWAY_COURSE_FLAG,NEXT_SEM_PRE_REGISTERED_FLAG,NEXT_SEMEST
ER_REGISTERED_FLAG,PROBATION_FLAG,PROBATION_DESCRIPTION,COM
PLETE_WITHDRAW_FLAG,COMPLETE_WITHDRAW_DATE,COMPLETE_WITHDRA
W_REASON,ROOMMATE_ASU_ID,ROOMMATE_FIRST_NAME,ROOMMATE_LAST_
NAME,ROOMMATE_MAJOR_DESCRIPTION,EARLY_WARNING_FLAG
1000742627,600231697,JOANNE,COY,WORTH,Y,20037,M,PP,PUBLIC
PROGRAMS,21,BACHELOR OF ARTS,0611,JOURNALISM/MASS
COMM,null,null,null,null,null,null,null,null,null,01,FRESHM
AN,ARIZONA RESIDENT FOR TUITION PURPOSES,N,UNKNOWN/NOT
APPLICABLE,N,,,,,,,CAMELBACK,ARIZONA,0.0,3.28,3.11,18,0,12.
0,N,0611,JOURNALISM/MASS COMM,N,UNKNOWN,,,,RELEASE ALL
DIRECTORY INFORMATION,2801 N 30TH
STREET,,PHOENIX,AZ,85008,602-230-
6116,[email protected],N,,0.0,,HUFF,KIMBERLY,Kimberly.Hu
(e-mail address removed),480/678-2933,N,0.0,N,Y,N,N,N,,N,,,,,,,N,
1000738290,601840816,TONY,HAMES,SILVAR,Y,20037,M,ES,ENGR &
APPLIED SCIENCES,32,B.S. IN ENGINEERING,0910,MECHANICAL
ENGINEERING,null,null,null,null,null,null,null,null,null,01
,FRESHMAN,ARIZONA RESIDENT FOR TUITION
PURPOSES,N,UNKNOWN/NOT APPLICABLE,N,,,,,,,CENTRAL-
PHOENIX,ARIZONA,0.0,3.47,3.32,20,1120,14.0,N,0910,MECHANICA
L ENGINEERING,Y,PALO VERDE MAIN,B,03,,RELEASE ALL
DIRECTORY INFORMATION,0125 PALO VERDE
MAIN,,TEMPE,AZ,85281,480-532-
9218,[email protected],N,,0.0,,SQUIRES,K,Email not
available,NotAvailable,N,0.0,N,Y,N,N,N,,N,,,993760009,EVAN,
FUJAD,NONE,N,
 
[This followup was posted to microsoft.public.excel.programming with an
email copy to Katherine.
Please use the newsgroup for further discussion.]

Two possibilities:

(1) Change the filetype to .txt and then open it in XL. The Text
Import Wizard will kick in.

(2) Select column A (the one with all the data). Select Data | Text To
Columns...

--
Trouble finding replies to your posts? Use a newsreader. See the
tutorial 'Outlook Express and Newsgroups' on my web site

Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 
Is the file named something like myfile.csv - in otherwords, does it have an
extension of .CSV?
 
Back
Top