Text formating

oluoch · #1 (**permalink**) 03-23-04, 05:59

Could anyone help me with this using sed or Awk.
I have got a text file with so many lines and i need to strip off unwanted xtars as below.
Input file contains:
Upperlands-Roadside/Main16x2|8+2Mbps/2Mb#1
Telsat-vineland/Main16x2|8+2Mbps/2Mb#1
market-university/Main8x2|8+2Mbps/2Mb#2
Runway-hall/Frame16x2|8+2Mbps/2Mb#1
Telsat-vineland/Main16x2|8+2Mbps/2Mb#1
market-university/Main8x2|8+2Mbps/2Mb#2
Runway-hall/Frame16x2|8+2Mbps/2Mb#1

All i need in Output file is:

Upperlands-Roadside
Telsat-vineland
market-university
Runway-hall
Telsat-vineland
market-university
Runway-hall

I have tried using this sed command to find the unwanted xters starting from the / and replacing it with no space but it does not work.
NB: Remember there are so many other columns in the input file

sed 's/[/][a-zA-Z0-9].[/]//'g inputfile > outputfile

gurey · #2 (**permalink**) 03-23-04, 07:33

Quote:

Originally posted by oluoch
Could anyone help me with this using sed or Awk.
I have got a text file with so many lines and i need to strip off unwanted xtars as below.
Input file contains:
Upperlands-Roadside/Main16x2|8+2Mbps/2Mb#1
Telsat-vineland/Main16x2|8+2Mbps/2Mb#1
market-university/Main8x2|8+2Mbps/2Mb#2
Runway-hall/Frame16x2|8+2Mbps/2Mb#1
Telsat-vineland/Main16x2|8+2Mbps/2Mb#1
market-university/Main8x2|8+2Mbps/2Mb#2
Runway-hall/Frame16x2|8+2Mbps/2Mb#1

All i need in Output file is:

Upperlands-Roadside
Telsat-vineland
market-university
Runway-hall
Telsat-vineland
market-university
Runway-hall

I have tried using this sed command to find the unwanted xters starting from the / and replacing it with no space but it does not work.
NB: Remember there are so many other columns in the input file

sed 's/[/][a-zA-Z0-9].[/]//'g inputfile > outputfile

HI,
Please test follow

cat file |awk -F"\/" '{print $1}'
or
sed 's/[\/][a-zA-Z0-9].[\/]//'g inputfile > outputfile

aigles · #3 (**permalink**) 03-23-04, 07:45

Try this :

Code:

awk -F'/' '{print $1}' input_file > output_file

sed 's!/.*!!' input_file > output_file

oluoch · #4 (**permalink**) 03-23-04, 07:59

Quote:

Originally posted by gurey
HI,
Please test follow

cat file |awk -F"\/" '{print $1}'
or
sed 's/[\/][a-zA-Z0-9].[\/]//'g inputfile > outputfile

I have tried both the sed and awk options but still do not work. Anymore ideas please to try?

aigles · #5 (**permalink**) 03-23-04, 08:15

You can also try to use the cut command :

Code:

cut -d'/' -f1 input_file > output_file

oluoch · #6 (**permalink**) 03-23-04, 08:39

Quote:

Originally posted by aigles
Try this :

Code:

awk -F'/' '{print $1}' input_file > output_file

sed 's!/.*!!' input_file > output_file

Thanks alot they all worked very well

Internet Services

Web Development

Digital Marketing

Consumer Tech