Trailing Spaces in Unix

[purush]

Hi,

My requirement is to read a file. Actually there will be a file in the ftp Common folder. We have a script that will take the file from there and keep it in our project folder. When I'm trying to do a view data...I'm unable to..... .

I did a VI and saw that there are some trailing spaces[^M] at the end of each line. I also tried by converting it to ascii mode and the ftp'd the file.....but still was helpless........


Please help me if u can suggest me any .........

Thanks in Advance
Purush...

[ray.wurlod]

^M is not a space character. It is a carriage return, or Ctrl-M, or Char(13). It suggests that this file was generated on a Windows system.

Try using a filter command in the Sequential File stage that uses tr -d to remove the \r characters.

[smrutiranjannayak]

Hey ,

Use the below command :

when to save ur file in Unix do this :

:%s/ctrlv+m//

means colon then % ,then s then / ,then control v and controll m ,then double slash

enjoy

[DSguru2B]

I think you mean, while in vi, save it as follows, right smrutiranjannayak?

[chulett]

Close. It's a command to remove the ^M characters. Problem is it's not quite right. To enter control characters, you first press Ctrl-V and then the character in question. To get a 'control M' you don't type an 'M' - you press ENTER after the Ctrl-V.

You would do this before saving. Best to get the Sequential File settings correct so the file can be read - there's nothing out of the ordinary here and is perfectly feasible to do. And an ASCII ftp to a UNIX box would have converted any <CR><LF> pairs to plain <LF> characters.

[snt_ds]

Hi Purush,

I had similer kind of issue, the following script helped me out to remove the carriage return.

if [ $UNAME = "SunOS" ]
then
dos2unix ${SRC_PATHNM}/$FILENM ${INT_PATHNM} $FILENM.dos2unix
grep -v "^$" ${INT_PATHNM}/$FILENM.dos2unix > ${INT_PATHNM}/$FILENM
rm -f ${INT_PATHNM}/$FILENM.dos2unix
exit 0
fi

Thanks,
snt_ds

[ray.wurlod]

Hey ,

Use the below command :

when to save ur file in Unix do this :

:%s/ctrlv+m//

means colon then % ,then s then / ,then control v and controll m ,then double slash

enjoy

Grammatical Note
Ur was a city in ancient Babylon. Please use correct English pronouns such as "your" here. Would you use "ur" in your professional documentation? We believe that DSXchange is a community of professionals.

[Cr.Cezon]

Note that in unix the trailing spaces are losted, i think for better performance.
if you don't want to loose these trailing spaces you must insert another caractere (example_ tab) at the end the record.

regards,
Cristina