AnsweredAssumed Answered

How can I find an unexpected record from a flat file?

Question asked by RanjiniElamkulammana2391 on Mar 4, 2016
Latest reply on Mar 7, 2016 by RanjiniElamkulammana2391

I have a flat file given below:

Order573*20*376f972*Ntwk Adpt*29.99*Company A

UniqueOrder675*40*Wireless Card*801 Cassatt Road*Berwyn*PA*19312*Call Tech Support Immediately*97G45E*sku4513

Order574*10*5247rt*Headphones*15.75*Company B

UniqueOrder676*25*Wireless Card*Address Unknown*NA*NA*NA*Call Tech Support Immediately*97G45E*sku4513

BA * * *

Order573*20*376f972*Ntwk Adpt*29.99*Company C

 

I have two records in the flatfile profile, where Detect This File Format By is set as "specified unique values". And the first element of both the records is set to some identity value.

 

The second last record(BA ***) is a junk/unexpected record. Is there a way I can find out the junk record and throw an error saying the unexpected record entry.

Outcomes