I am trying to clean up a text-to-columns tool, and I am wondering if there is a way to delete or make null a certain amount of rows. For example, if the row says "DATE:" then make that and the next 5 rows null.
It might actually be easiest to do this with a filter tool using a custom filter:
!Contains([data],"Date:" AND !Contains([data],"TIME:" AND !Contains([data],"--------------" AND !Contains([data],"UNIT" AND !Contains([data],"ID."
This worked, thank you!
Hi Brandon,
What if I want to get rid of "Deductible State Tax:" and the following N of states? Is there an easier way to do that without having to type out the custom filter for each N of states? Or is there another tool I can use? I tried using the Sample tool but I need all of the rows before and after the state info.
Thanks!
Jeanette
