How to skip that filtered value from text file on XMLPORT?

undy0602

hello developers,
I have to import a text file into NAV via XMLPORT in NAV2016. But this text file has mixed value. I cant edit to fix manually into it. So I have to filter some value and skip it. How can I skip this filtered value on xmlport?

Regards,
Undy

mohana_cse06

You can import into a temp table and then move the data to original table with your filters

undy0602

Thanks Mohana,
But I cant import into temp table too. Because there are mixed value in one field. Doesnt match data type. Can I check data type or data length? How can I skip these rows?
Example:
11/23/2015 06:08:09 06:08:24
11/23/2015 06:08:24 06:08:39
11/23/2015 06:08:24 Playback stopped -> want to skip this row
11/23/2015 06:08:25 Playback started -> want to skip this row
11/23/2015 06:08:30 06:08:24

Regards,
Undy

Wisa123

Then i would just suggest to look for those rows OnBeforeInsertRecord as you iterate through the file (look for Keywords you wanna skip, ...) and then just call currxmlport.skip accordingly