anushahanna
asked on
how is csv file recognized
sometime i do not see any special character in how columns are listed in the csv file.
how does the system recognize which columns are what and how the data is assigned?
thanks
how does the system recognize which columns are what and how the data is assigned?
thanks
Col1,Col2,Col3,Col4,Col51,2,3,4,5,6,7,8,9,10
Col1,Col2,Col3,Col4,Col5<char>1,2,3,4,5<char>6,7,8,9,10<char>
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Col1,Col2,Col3,Col4,One,Tw o,Three,Fo ur,Five,Si x,Seven,Ei ght
How does the system decipher the above. I am meaning 2 records. what is intelligent in the above csv that the system can pick it up- if it can't what should do to help it?
How does the system decipher the above. I am meaning 2 records. what is intelligent in the above csv that the system can pick it up- if it can't what should do to help it?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thanks all - i am trying to absorb all the input...
the background of this is this:
attached soi format works with my program. but now the source is coming from a diff place with csv format, but it does not work- i am wondering if there is any fundamental issue with the csv char formatting that was not so in the soi file.
the columns are different- they can be mapped once the csv file is made to work. just renaming the file to soi did not help.
please rename test1.txt to test1.soi
thank you.
test2.csv
test1.txt
the background of this is this:
attached soi format works with my program. but now the source is coming from a diff place with csv format, but it does not work- i am wondering if there is any fundamental issue with the csv char formatting that was not so in the soi file.
the columns are different- they can be mapped once the csv file is made to work. just renaming the file to soi did not help.
please rename test1.txt to test1.soi
thank you.
test2.csv
test1.txt
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thanks very much - I have told the source programmer to take note of what is found and fix it.
appreciate it.
appreciate it.
ASKER
http://www.tedmontgomery.com/tutorial/altchrc.html