Thread: DML for excel csv source

I am a newbie to Abinitio Technology and i want to know how an excel/csv (source file) can be chose as input/source file for the input file component. How can we write a DML for the same if the source file column has variable length.

Thanks and appreciate help and guidelines from you all for my learnings.

Hi
For ur query, we can use delimeter

example,

record
decimal(',') custid;
string('\r\n') custname;
end

Hi,

I am giving good example to understand the delemeter.

In Ab Initio Log flows also has variable lenth.

Logging flows have predefined metadata.

The log port record format is:



record
string("|") node;
string("|") timestamp;
string("|") component;
string("|") subcomponent;
string("|") event_type;
string("|\n") event_text;
end

Regards

Raja

Together. Free your energies