Topic
IC4NOTICE: developerWorks Community will be offline May 29-30, 2015 while we upgrade to the latest version of IBM Connections. For more information, read our upgrade FAQ.
No replies
SystemAdmin
SystemAdmin
603 Posts
ACCEPTED ANSWER

Pinned topic jaql schema with semi column delimiter

‏2013-03-14T06:55:17Z |
Hi

i have used the following text file with 3 columns empid,name,place and they are separated with semicolumn delimiter

emp001;"John",Paul,Prince;USA
emp002";Smith;UK
emp003;James;sec;UK

and i have defined following query for schema and it worked fine.

data = read(del(location="swarna/emp4.txt",delimiter =";" ,schema = schema{ empid, name, place}));

but i am getting an error ( delimiter missing in field starting at position 6) when i count the fileds using following query

data -> group into count($);

can any one suggest me how to define schema for my input file....

i have attached a file(error) please find it.....