AWK suffixes are overwriting the original text.

I'm using awk to add the filename after the text on each line like this:
but the filename overwrites the original text starting at position zero.

The filename is test.txt

Example of text in the file:

Here is a long line of text

Expected output:

Here is a long line of text -- test.txt

But what I'm getting:

-- text.txtong line of text

I can add a carriage return or newline carriage return pair and see the original text just fine:

Here is a long line of text

-- test.txt

so I know the original data still exists. I can also prepend the text and that works fine. The problem only asserts itself as suffixes are being added but I can't alter the positioning because I'm copying data into a database.

Any help would be appreciated.
Thanks in advance.

Welcome to LQ and the Programming forum!

Perhaps we should begin by asking the meaning of your example

Is the closing square bracket a typo? If not, how do you think it will be interpreted by your awk command?

Assuming it is a typo and your file is indeed named test.txt, I get this:

It would be helpful if you would tell us the platform and version of awk you are using.

Also, check the test.txt file for presence of any non-printing special characters which might affect the positioning of the FILENAME output.

The square bracket is part of a "test" in bash ?. So we're not being told the entire story ?. Maybe Windows text input ?. Maybe already (partially) munged ?.

Showing us a symptom without a proper description of the actual problem isn't going to help anyone.

1 members found this post helpful.

that awk works ( without closing ] ), so if you have a problem with your script it is not that awk, but something else, which was not posted.

1 members found this post helpful.

The issue was that the file was created on a windows system and had carriage return line feeds at the end of each line. So the suffix printed after the line feed.
Adding {RS="\r\n"} to my awk statement fixed everything.

I appreciate the attention and support.

P.S. And I was trying to tell the entire story sysg00.

A sub() deletes a \r at the end, so it will take a DOS or Unix input: