Regarding CSV type files

veera24 · Post by **veera24** » Thu Mar 13, 2008 9:50 pm

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

kumar_s · Post by **kumar_s** » Thu Mar 13, 2008 11:22 pm

Use psv. Pipe seperated values. Now Pipe will be the field delimiter.

ray.wurlod · Post by **ray.wurlod** » Fri Mar 14, 2008 12:50 am

Or tab-delimited. Tabs in data are fairly rare, since tab in Windows applications moves one to the next field.

chulett · Post by **chulett** » Fri Mar 14, 2008 7:42 am

Or force the columns to be 'Text', then I would think Excel would quote the string and the comma won't be a problem.

veera24 · Post by **veera24** » Fri Mar 14, 2008 9:38 pm

kumar_s wrote:Use psv. Pipe seperated values. Now Pipe will be the field delimiter. ...

Thanks kumar...I've used PSV and got the soln. Thanks for ur time

veera24 · Post by **veera24** » Fri Mar 14, 2008 9:42 pm

kumar_s wrote:Use psv. Pipe seperated values. Now Pipe will be the field delimiter. ...

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.

Thanks in advance

veera24 · Post by **veera24** » Fri Mar 14, 2008 9:46 pm

ray.wurlod wrote:Or tab-delimited. Tabs in data are fairly rare, since tab in Windows applications moves one to the next field. ...

Ray
as u said i've changed the format to tab delimited and stored it and how can i give the delimiter value in Datastage?Ur time is highly appreciated.

Thanx..

ray.wurlod · Post by **ray.wurlod** » Fri Mar 14, 2008 10:17 pm

Specify the delimiter as 009.

Read the Help (press F1 while in the Format page) to see how you specify non-printing delimiter characters.

veera24 · Post by **veera24** » Sat Mar 15, 2008 5:47 am

ray.wurlod wrote:Specify the delimiter as 009.

Read the Help (press F1 while in the Format page) to see how you specify non-printing delimiter characters. ...

thnx ray

chulett · Post by **chulett** » Sat Mar 15, 2008 7:50 am

Looks like it's time to step in for Ray and asked you to mark this one as Resolved.

ray.wurlod · Post by **ray.wurlod** » Sat Mar 15, 2008 4:24 pm

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.