使用多个页眉,正文和页脚记录来修改平面文件。 [英] Debatching a flat file with multiple header ,body and Footer Records.
问题描述
我正在尝试将下面的文件分发到单个记录中,但无法设法这样做。
I am trying to debatch below file into individual records but could not manage to do so.
START-OF-FILE
PROGRAMNAME = getcalendar
DATEFORMAT = yyyymmdd
START-OF-FIELDS
CDR_CODE
CALENDAR_TYP
CALENDAR_NAME
日历
END -OF-FIELDS
START-OF-FILE
PROGRAMNAME=getcalendar
DATEFORMAT=yyyymmdd
START-OF-FIELDS
CDR_CODE
CALENDAR_TYP
CALENDAR_NAME
CALENDAR
END-OF-FIELDS
START-OF-DATA
CDR 0A | 0 | 4 | 0A |国家|澳大利亚/南|; 2; 1690; 1; 5; 20070101; 5; 20070106; 5; 20070107; 5; 20070113; 5; 20070114; |
$
CDR TE | 0 | 4 | TE | Misc | TARGET |; 2; 7211; 1; 5 ; 19950101; 5; 19950107; 5; 19950108; 5; 19950114; 5; 19950115; |
$
END-OF-DATA
DATARECORDS = 517
END-OF-FILE
START-OF-DATA
CDR 0A|0|4|0A|Country|Australia/South|;2;1690;1;5;20070101;5;20070106;5;20070107;5;20070113;5;20070114;|
CDR TE|0|4|TE|Misc|TARGET|;2;7211;1;5;19950101;5;19950107;5;19950108;5;19950114;5;19950115;|
END-OF-DATA
DATARECORDS=517
END-OF-FILE
上面的示例包含标题,从CDR开始的2条记录,其余的是预告片。
THe above sample contains Header ,2 records starting from CDR and rest is trailer.
有人可以提供帮助我这个?我需要将其分配到单独的消息中,以便我可以相应地处理它们。
Can someone help me on this ? I need to debatch this into individual messages so that i can process them accordingly.
推荐答案
您是否创建了架构?
Have you created schema ?
请发布示例文件。
问候
Mohit gupta
Mohit gupta
这篇关于使用多个页眉,正文和页脚记录来修改平面文件。的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!