nls_read_delimited() - invalid quotes

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

vinaymanchinila
Premium Member
Premium Member
Posts: 353
Joined: Wed Apr 06, 2005 8:45 am

Post by vinaymanchinila »

tested it and it works, may be there was a mix up on the ' and ", sorry !
Thanks
vinaymanchinila
Premium Member
Premium Member
Posts: 353
Joined: Wed Apr 06, 2005 8:45 am

Post by vinaymanchinila »

I have no idea Naveen!
yaminids
Premium Member
Premium Member
Posts: 387
Joined: Mon Oct 18, 2004 1:04 pm

nls_read_delimited() - invalid quotes

Post by yaminids »

Hi Vinay,

I faced the same problem. In my case the problem was caused with 'Line feed' or 'Carriage return'. I used the following code to solve the problem:

Convert(Char(10):Char(13),"",InputLine.Col1)

Hope this helps you
Yamini
Post Reply