Regarding CSV type files
Moderators: chulett, rschirm, roy
Regarding CSV type files
hi all,
Am having excel sheet as the source for my job. I've saved that XLS sheet in CSV format. Since it is a CSV file, i gave comma(,) as a delimiter. But one of my address field column looks like this:170,Pine Street,New York.
DS taking this as three diff columns and am not getting the right output.
Is there any other way to effectively use Excel sheet as the source instead of converting into CSV file format.Your time is highly appreciated.
Thanks in advance...
veera
Am having excel sheet as the source for my job. I've saved that XLS sheet in CSV format. Since it is a CSV file, i gave comma(,) as a delimiter. But one of my address field column looks like this:170,Pine Street,New York.
DS taking this as three diff columns and am not getting the right output.
Is there any other way to effectively use Excel sheet as the source instead of converting into CSV file format.Your time is highly appreciated.
Thanks in advance...
veera
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
I can able to get the data from XLS sheet into PSV format provided if am supposed to extract the data from MS Access(as of my knowledge).How can i implemnt the same in an ordinary XLS sheet because i haven't found the PSV format.I found TAB Delimited(as ray said) and many stuffs.kumar_s wrote:Use psv. Pipe seperated values. Now Pipe will be the field delimiter. ...
Thanks in advance
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Instead of that I will make my oft-repeated plea for professional standards of written English.
The second person personal pronoun in English is spelled "you", not "u". Its possessive form is spelled "your", not "ur". The contraction of "you are" is spelled "you're", not "ur" or "your".
The first person personal pronoun is usually capitalized (that is, "I" not "i").
The word "Thanks" has vowels in it.
Oh, and do please mark the thread as resolved.
The second person personal pronoun in English is spelled "you", not "u". Its possessive form is spelled "your", not "ur". The contraction of "you are" is spelled "you're", not "ur" or "your".
The first person personal pronoun is usually capitalized (that is, "I" not "i").
The word "Thanks" has vowels in it.
Oh, and do please mark the thread as resolved.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.