Deleting Junks at the end of each line in a file - UNIX Desktop for Dummies Questions & Answers

dave_nithis · #1 (**permalink**) 10-03-2007

Is there any way to delete the Junk Characters(Invalid Characters like ^,',",),(,&,# etc.,) at the end of each record in a file?

I want to do this using a single line script.

Thanks to all in advance!!!

porter · #2 (**permalink**) 10-04-2007

Define "junk"

Define "record"

Define "single line script", is back-slash allowed? What about the interpretor indicator in the first line? Does it have to fit in 131, 79 or 65 characters?

Are there any other nefarious restrictions, like can't use sed or awk?

dave_nithis · #3 (**permalink**) 10-04-2007

Single line Script - You can use any commands but i dont want for loop,if loop,while loop etc.,I want a simple script.

Record - Am calling Each line in a file as record

Junk - As I said unwanted characters including backslash

Ex:
"401","1G1AL55F377159935 ",30482,"MD","3","09/17/2007",9000 -Valid record
"401","1G1AL55F377159935 ",30482,"MD","3","09/17/2007",9000[ - invalid
"401","1G1AL55F377159935 ",30482,"MD","3","09/17/2007",9000; - invalid
"401","1G1ZT58N47F140841 ",29098,"MD","3","09/17/2007",10600'" - invalid
"401","1G1ZT68N57F138781 ",27403,"GA","1","09/17/2007",10100' - invalid
"401","1G4HD57227U217222 ",7163,"MI","3","09/17/2007",21600: - invalid

You can certainly use awk or sed!!
Thanks!

porter · #4 (**permalink**) 10-04-2007

Quote:

Originally Posted by dave_nithis

Junk - As I said unwanted characters including backslash

We don't know what you don't want, do you mean all non numeric characters?

Is it always a single character at the end?

porter · #5 (**permalink**) 10-04-2007

As I'm not into awk, here is something else...

Code:

#include <stdio.h>
#include <string.h>

static int is_junk(c)
int c;
{
	if ((c >= '0')&&(c <='9')) return 0;
	return 1;
}

int main()
{
char buf[4096];

	while (fgets(buf,sizeof(buf),stdin))
	{
		int i=strlen(buf);
		while (i--)
		{
			if ((buf[i]=='\n')||is_junk(buf[i]))
			{
				buf[i]=0;
			}
			else
			{
				break;
			}
		}
		printf("%s\n",buf);
	}

	return 0;
}

ghostdog74 · #6 (**permalink**) 10-04-2007

try this

Code:

awk 'BEGIN{OFS=FS=","}{$NF=$NF+0}1' file

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
deleting a line but keeping the same file	laiko	UNIX for Dummies Questions & Answers	2	05-13-2008 11:08 AM
Deleting end of line $ character in file	bwrynz1	UNIX for Advanced & Expert Users	3	01-08-2008 09:17 AM
Deleting all content in a file from command line	kingdbag	UNIX for Dummies Questions & Answers	2	07-20-2006 04:00 PM
Deleting the blank line in a file and counting the characters....	rkumar28	Shell Programming and Scripting	4	04-17-2005 09:13 AM
Deleting end line spaces for along file	osymad	Shell Programming and Scripting	3	02-23-2005 09:56 AM

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode