remove the trailing spaces or charaters after particular format

vjkiran · #1 (**permalink**) 02-21-05, 15:33

Hi
here is my problem.
I have a huge file , each and everly line ends with 00/00/0000 ,,,,,,,,,,,,,,,,,,( 18 commas)
All I need to do is , I have to ignore whatever the spaces or any more commas after that . Or I have to remove the remaining spaces or commas at the end of the line .
how can i do it using Unix script.

Your help will be appreciated.
Thanks
Vijay

vgersh99 · #2 (**permalink**) 02-21-05, 16:30

pls give a sample input AND a desired output.

vjkiran · #3 (**permalink**) 02-21-05, 16:48

abcdk l lklk dsjdl lklk sds00/00/0000,,,,,,,,,,,,,,,,,,
dsdsdsdssdsasasasasas00/00/0000,,,,,,,,,,,,,,,,,,
abcsdsdsd sdsdsdk l lklk dsjdl lklk sds00/00/0000,,,,,,,,,,,,,,,,,,
abcdk l lklk dsjdl lklk sds00/00/0000,,,,,,,,,,,,,,,,,,

this the sample data, it is ending with (00/00/0000 and 18 commas ) and some empty spaces
I need to make it ending with (00/00/0000 and 17 commas) with no spaces at the end.

Thanks in advance
vijay

vgersh99 · #4 (**permalink**) 02-21-05, 17:14

nawk -f vijay.awk file

vijay.awk:

Code:

BEGIN {
   PAT="sds00/00/0000,,,,,,,,,,,,,,,,,,[ ]*$"
   PATnew="sds00/00/0000,,,,,,,,,,,,,,,,,"
}
$0 ~ PAT {
      sub(PAT, PATnew, $0)
}
1

or with sed:

Code:

sed -e 's#\(00/00/0000\)[, ][, ]*$#\1,,,,,,,,,,,,,,,,,#g' file

vjkiran · #5 (**permalink**) 02-21-05, 17:29

I greatly appreciate your help and fast response.
I did in a different method also.
here is what i did. I removed all trailing spaces in first tiem then I substituted with 00/00/0000 and 18 spaces with 17 spaces.

your method also works great but it still have the trailing spaces.

Thank you very much vlad.

Vijay

vgersh99 · #6 (**permalink**) 02-21-05, 17:37

my version does remove trailing spaces - tested on Solaris's nawk/sed.
are you sure those are spaces? maybe tabs or control chars?

Internet Services

Web Development

Digital Marketing

Consumer Tech