delimiters in file

bhargav_dd · Post by **bhargav_dd** » Mon Oct 17, 2011 11:50 pm

hi all,

i got stuck up with one requirement

i am getting a pipe delimited file
and in that i am getting records with pipe like this
abc|xyz|1|
how can we handle this in datastage?

appreciate ur response

ray.wurlod · Post by **ray.wurlod** » Tue Oct 18, 2011 12:06 am

bhargav_dd wrote:appreciate ur response

Ur...

ray.wurlod · Post by **ray.wurlod** » Tue Oct 18, 2011 12:08 am

Specify | as the field delimiter.

You have four fields. If you only really have three, specify | as the final delimiter too.

ray.wurlod · Post by **ray.wurlod** » Tue Oct 18, 2011 12:11 am

Ur was a city in ancient Babylonia.

The second person personal pronoun in English is spelled "your", not "ur".

Please strive to maintain a professional standard of written English on DSXchange, not least because it helps those whose first language is not English.

Also strive to be professional because use of SMS-style abbreviations in other than an SMS environment irks (urks?) me.

bhargav_dd · Post by **bhargav_dd** » Wed Oct 19, 2011 5:33 am

ray.wurlod wrote:Ur was a city in ancient Babylonia.

The second person personal pronoun in English is spelled "your", not "ur".

Please strive to maintain a professional standard of written English on DSXchange, not least because it helps those whose first language is not English.

Also strive to be professional because use of SMS-style abbreviations in other than an SMS environment irks (urks?) me.

dont look small things in microscopic view and if you know the answer tell dont bother about pronounciations

ray.wurlod · Post by **ray.wurlod** » Wed Oct 19, 2011 4:11 pm

When you exceed my post count I will be happy to consider your opinions about my professionalism.

You did not even acknowledge that I did provide an answer.

SURA · Post by **SURA** » Wed Oct 19, 2011 6:06 pm

A coin is always have two sides. You are looking into your side and consider the other side. Yes it is a small thing, still you can follow the professional approach.

Hence you are in the forum from 2009, you might noticed these type of comments by Ray, good number of times, but still you did the same thing!!

I know when someone is expecting something and not getting it in that time will create forestation, but that doesn't mean that your expression is correct.

Always try to learn (Its included me too) good things from others.

DS User

abc123 · Post by **abc123** » Wed Oct 19, 2011 8:32 pm

bhargav_dd, what Ray has said about your English is 100% correct. If you write SMS type English, it becomes very difficult to read especially when people are going through a lot of posts to search a solution.

He gave you an answer right away which probably would have cost you several hundred dollars to get from a support provider.

He made this site an enormously rich resource for Datastage developers and contributed to the careers of thousands of them.

prakashdasika · Post by **prakashdasika** » Thu Oct 20, 2011 12:33 am

Well, all of us participating in the forum want to be/are already professionals. There is no harm to set some standards while communicating.

delimiters in file

delimiters in file

Re: delimiters in file