Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Delimited Text Driver Validation on Input File Header and Trailer

7 views
Skip to first unread message

minyi...@xynapse-asia.com

unread,
Oct 27, 2014, 5:16:45 AM10/27/14
to
Hi,

I need to design the delimited text driver in a way as mentioned below.

CSV input file where I need to check for the header and trailer. When both are exists, then it is a valid file and the data should be process accordingly. If either 1 is missing, then the input file is considered as an invalid input file and should not be processing.

The input file format will be similar as below.

01|Header
02|Data1|Data2|Data3
02|Data1|Data2|Data3
02|Data1|Data2|Data3
03|Trailer

01 is the Header, 02 is the content where no fix number of rows(Can be 10 rows in File 1, 100rows in File 2), 03 is the trailer.

Any ideas on how I can achieve it and make my delimited text driver to behave as per above requirements?

Thanks in advanced.

Have a good day.

Lothar Haeger

unread,
Dec 5, 2014, 3:15:43 PM12/5/14
to
minyi...@xynapse-asia.com wrote:

> I need to design the delimited text driver in a way as mentioned below.

this is a really old forum. Please go to
https://forums.netiq.com/forumdisplay.php?19-Identity-Manager and post in the
appropriate subforum (also available via nntp.netiq.com if you prefer the good
old usenet style).
0 new messages