cancel
Showing results for 
Search instead for 
Did you mean: 

Remove Footer - FIxed width file

Mari
New Contributor

I am trying to load the data from fixed width flat file. In Fixed-Width Parser snap i can able to remove header through skip option. But can i know , is there any possible way to remove the footer ?

4 REPLIES 4

dwhansen-cbg
Contributor

This one’s been sitting here for a while and was never answered, but I’m having a similar issue. I’m wondering how to remove the last row(s) from a file.

tlikarish
Employee
Employee

Would the Tail snap be helpful for either of your cases? If you were certain that the number of rows in the file wouldn’t surpass a certain limit, then you could do something like this.

image

alchemiz
Contributor III

Hi Mari/Davis,

Good day, you can try to maximize the Ignore Lines properties of the Fixed width parser.

e.g.

I assumed that the footer is an empty line? you can use the regex ^(?![\s\S])

But this is a kinda global thing, it will ignore all empty lines 🙂

image

This is the correct solution. I’ve used this solution for fixed width but didn’t even realize it could be used for CSV files too. I’ll give it a shot.