How to remove a column in a text

Hi @norasaied,

Welcome to the Community! If I'm understanding correctly that you want to remove the attriibute, you can remove it using an AttributeRemover. Conversely you can also deselect it in the writer (under User Attributes, remove the ADDRESS_ID attribute) and it will not write out.

Hi @norasaied, I guess that the source text file is a TSV (tab-separated values) formatted table. If so, you could use the CSV reader to read the table using the first line as field names row and tab as delimiter character, then remove unnecessary columns with the AttributeRemover, as @jovitaatsafe suggested.

Actually I meant a row -- is it the same procedure?

Actually I meant a row -- is it the same procedure?

And would not like to remove it, just 'filter' it out.

Thanks @jovitaatsafe

I just want to know if the source text is tab-separated values formatted. If you could post the text file here, it would help us to find an appropriate solution.

It is a .txt file. Here is an image of the text file.

Cannot identify how the table is formatted only by looking screenshots.

I guess that the text table is formatted with tab-separated values. If so, you can read the table with the CSV reader then remove unnecessary columns easily.

Did you try reading the text with the CSV reader?

If you could post the actual text file here as an attachment (or a small section of it, the top couple of rows, as long as they have the one you're trying to filter out) that would help us a lot in trying to help you.

@norasaied from your example it looks like you can use a TESTER.

You can use the example settings for any row filter. I use it all the time.

You may need to play with the syntax a little but I think you can get the idea.