Problem with carriage return 2

[TSch]

Hi folks,

I'm facing a quite annoying problem. Maybe you got an idea how to solve it.

On a daily basis there's an automated SAP Job generating a file.txt under a certain directory of the AIX machine.

Let's say the file contents look like this:

Person 1;Address;Phone       ;
Person 2;Address;Phone       ;
Person 3;Address;Phone       ;

Performing a

cat file.txt

everything looks fine.

However the directory is accessible by Windows using a Samba share and if we open the file using notepad or something similar it looks something like this:

Person 1;Address;Phone       ;0Person 2;Address;Phone       ;0Person 3;Address;Phone       ;

Note: There's not really a "0" between every line. It's more like some kind of square symbol representing some sort of carriage return. Problem is I can't display the symbol here, so I chose the "0" instead.

Now the question is: Do you have any idea how to get the file being displayed correctly under Windows ?

Problem is that we're running automated procedures on both sides (AIX and Windows) and we're unable to simply open the file with another application (e.g. Wordpad). It is important to automatically format the file somehow so that it is going to be displayed correctly under notepad ...

Regards
Thomas

 

[hiasor]

you can try
dos2unix
or
cat filename|sed 's/'`echo "\010\013"`'/'`echo "\013"`'/g' > filenew
or
cat ${filename} | tr -d '\r' > ${filename}.new
or
sed -e 's/^M//g' $input_file > $input_file.fmt
or
sed -e 's/[^ -~]//g' $input_file > $input_file.fmt

 

[TSch]

I tried the commands, but I'm afraid that didn't do it ...

Regards
Thomas

 

[p5wizard]

Well, no, it's unix2dos that's needed... Or else use a smarter program at the windows side: e.g. wordpad does know how to handle UNIX text files.
Then there's also notepad++ which I think is freeware (

http://notepad-plus.sourceforge.net/uk/site.htm).

HTH,

p5wizard

 

[TSch]

Problem is there's some VB stuff involved reading the file content and there seems to be now way to get rid of the faulty CR display there.

We need to change the file somehow, so that Windows displays it correctly no matter what application is being used to display the file contents ...

Best point of time would be on AIX level as soon as the files have been created.

Regards
Thomas

 

[p5wizard]

Why don't you have the SAP programmers write the file in DOS text mode?

Or else

[tt]sed "s/$/`echo \\\r\\\c`/" </path/to/unix/file >/path/to/windows/file[/tt]


HTH,

p5wizard

 

[mrn]

As P5 says try wordpad instead of notepad or even better textpad which can handle *nix files.

Mike

"Whenever I dwell for any length of time on my own shortcomings, they gradually begin to seem mild, harmless, rather engaging little things, not at all like the staring defects in other people's characters."

 

[TSch]

Hi folks,

finally we found a working command. Here it is:

perl -p -e 's/\n/\r\n/' < unixfile.txt > winfile.txt

Thanks for all your great support !

Regards
Thomas