|
Data string ends up in first cell instead of Comma sepaerated CSV format
[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 In article , says... 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_NA ME,CURREN TLY_ENROLLED_FLAG,SEMESTER,COLLEGE_CAMPUS_CODE,COL LEGE_OR_D IVISION_CODE,COLLEGE_DESCRIPTION,DEGREE_CODE,DEGRE E_DESCRIP TION,MAJOR_CODE,MAJOR_DESCRIPTION,DARS_MINOR_1,DAR S_MINOR_2 ,DARS_MINOR_3,DARS_CONCENTRATION_1,DARS_CONCENTRAT ION_2,DAR S_CONCENTRATION_3,DARS_CERTIFICATE_1,DARS_CERTIFIC ATE_2,DAR S_CERTIFICATE_3,ACADEMIC_LEVEL_CODE,ACADEMIC_LEVEL _DESCRIPT ION,ARIZONA_RESIDENCY_DESCRIPTION,CONDITIONAL_ADMI T_FLAG,CO NDITIONAL_ADMIT_REASON_DESC,HIGH_SCHOOL_DEFICIENCY _FLAG,HIG H_SCHOOL_ENGLISH_DEFICIENCY,HIGH_SCHOOL_ARTS_DEFIC IENCY,HIG H_SCHOOL_LANGUAGE_DEFICIENCY,HIGH_SCHOOL_MATH_DEFI CIENCY,HI GH_SCHOOL_LAB_SCIENCE_DEFICIENCY,HIGH_SCHOOL_SOCIA L_SCIENCE _DEFICIENCY,HIGH_SCHOOL_NAME,HIGH_SCHOOL_STATE_DES CRIPTION, HIGH_SCHOOL_CLASS_RANK_PERCENT,HIGH_SCHOOL_GPA,ABO R_HS_GPA, ACT_COMPOSITE_EXAM_SCORE,SAT_COMBINED_EXAM_SCORE,E NROLLED_H OURS,CHANGED_MAJOR_FLAG,CENSUS_MAJOR_CODE,CENSUS_M AJOR_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_NU MBER,EMAI L_ADDRESS,ASU_EMPLOYEE_FLAG,ASU_JOB_TITLE,ASU_TOTA L_FTE_PER CENTAGE,ASU_HR_DEPARTMENT_NAME,ADVISOR_LAST_NAME,A DVISOR_FI RST_NAME,ADVISOR_EMAIL_ADDRESS,ADVISOR_EMPLOYEE_PH ONE,BELOW _2_GPA_FLAG,CUMULATIVE_GPA,LOW_MID_TERM_GRADE_FLAG ,TAKING_G ATEWAY_COURSE_FLAG,NEXT_SEM_PRE_REGISTERED_FLAG,NE XT_SEMEST ER_REGISTERED_FLAG,PROBATION_FLAG,PROBATION_DESCRI PTION,COM PLETE_WITHDRAW_FLAG,COMPLETE_WITHDRAW_DATE,COMPLET E_WITHDRA W_REASON,ROOMMATE_ASU_ID,ROOMMATE_FIRST_NAME,ROOMM ATE_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- ,,HUFF,KIMBERLY,Ki mberly.Hu 1000738290,601840816,TONY,HAMES,SILVAR,Y,20037,M,E S,ENGR & APPLIED SCIENCES,32,B.S. IN ENGINEERING,0910,MECHANICAL ENGINEERING,null,null,null,null,null,null,null,nul l,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- ,,SQUIRES,K,Email not available,NotAvailable,N,0.0,N,Y,N,N,N,,N,,,993760 009,EVAN, FUJAD,NONE,N, |
Data string ends up in first cell instead of Comma sepaerated CSV format
Is the file named something like myfile.csv - in otherwords, does it have an
extension of .CSV? -- Regards, Tom Ogilvy Katherine wrote in message ... 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_NA ME,CURREN TLY_ENROLLED_FLAG,SEMESTER,COLLEGE_CAMPUS_CODE,COL LEGE_OR_D IVISION_CODE,COLLEGE_DESCRIPTION,DEGREE_CODE,DEGRE E_DESCRIP TION,MAJOR_CODE,MAJOR_DESCRIPTION,DARS_MINOR_1,DAR S_MINOR_2 ,DARS_MINOR_3,DARS_CONCENTRATION_1,DARS_CONCENTRAT ION_2,DAR S_CONCENTRATION_3,DARS_CERTIFICATE_1,DARS_CERTIFIC ATE_2,DAR S_CERTIFICATE_3,ACADEMIC_LEVEL_CODE,ACADEMIC_LEVEL _DESCRIPT ION,ARIZONA_RESIDENCY_DESCRIPTION,CONDITIONAL_ADMI T_FLAG,CO NDITIONAL_ADMIT_REASON_DESC,HIGH_SCHOOL_DEFICIENCY _FLAG,HIG H_SCHOOL_ENGLISH_DEFICIENCY,HIGH_SCHOOL_ARTS_DEFIC IENCY,HIG H_SCHOOL_LANGUAGE_DEFICIENCY,HIGH_SCHOOL_MATH_DEFI CIENCY,HI GH_SCHOOL_LAB_SCIENCE_DEFICIENCY,HIGH_SCHOOL_SOCIA L_SCIENCE _DEFICIENCY,HIGH_SCHOOL_NAME,HIGH_SCHOOL_STATE_DES CRIPTION, HIGH_SCHOOL_CLASS_RANK_PERCENT,HIGH_SCHOOL_GPA,ABO R_HS_GPA, ACT_COMPOSITE_EXAM_SCORE,SAT_COMBINED_EXAM_SCORE,E NROLLED_H OURS,CHANGED_MAJOR_FLAG,CENSUS_MAJOR_CODE,CENSUS_M AJOR_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_NU MBER,EMAI L_ADDRESS,ASU_EMPLOYEE_FLAG,ASU_JOB_TITLE,ASU_TOTA L_FTE_PER CENTAGE,ASU_HR_DEPARTMENT_NAME,ADVISOR_LAST_NAME,A DVISOR_FI RST_NAME,ADVISOR_EMAIL_ADDRESS,ADVISOR_EMPLOYEE_PH ONE,BELOW _2_GPA_FLAG,CUMULATIVE_GPA,LOW_MID_TERM_GRADE_FLAG ,TAKING_G ATEWAY_COURSE_FLAG,NEXT_SEM_PRE_REGISTERED_FLAG,NE XT_SEMEST ER_REGISTERED_FLAG,PROBATION_FLAG,PROBATION_DESCRI PTION,COM PLETE_WITHDRAW_FLAG,COMPLETE_WITHDRAW_DATE,COMPLET E_WITHDRA W_REASON,ROOMMATE_ASU_ID,ROOMMATE_FIRST_NAME,ROOMM ATE_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- ,,HUFF,KIMBERLY,Ki mberly.Hu 1000738290,601840816,TONY,HAMES,SILVAR,Y,20037,M,E S,ENGR & APPLIED SCIENCES,32,B.S. IN ENGINEERING,0910,MECHANICAL ENGINEERING,null,null,null,null,null,null,null,nul l,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- ,,SQUIRES,K,Email not available,NotAvailable,N,0.0,N,Y,N,N,N,,N,,,993760 009,EVAN, FUJAD,NONE,N, |
| All times are GMT +1. The time now is 02:45 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com