Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Remove characters from the file

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Remove characters from the file
# 1  
Old 05-08-2013
Remove characters from the file
i know , the below question has been repeated.
can you guys guide me .

I have the below input

Code:
999999 xxxxxxxxxxxxxx    123.45  2013-05-02 08:14 1 1 1 xxxx
999999 xxxxxxxxxxxxxx    123.45  2013-06-02 02:14 1 4 1 dddd

i need to remove from the column 54 to 70 , as like the below output.

Code:
999999 xxxxxxxxxxxxxx    123.45   1 1 1 xxxx
999999 xxxxxxxxxxxxxx    123.45   1 4 1 dddd

thanks in advance ! ! !
Last edited by joeyg; 05-08-2013 at 12:02 PM.. Reason: Please wrap commands and data inside CodeTags.
# 2  
Old 05-08-2013
Code:
sed 's#[1-9][0-9][0-9][0-9]-.*:[0-9][0-9] ##g' file

# 3  
Old 05-08-2013
Have you tried a cut command?
something like: cut -f1-3,6-9

Code:
$ echo 999999 xxxxxxxxxxxxxx    123.45  2013-05-02 08:14 1 1 1 xxxx | cut -d" " -f1-3,6-9
999999 xxxxxxxxxxxxxx 123.45 1 1 1 xxxx

# 4  
Old 05-08-2013
It can also be done either of the below way:

awk '{print $1 " " $2 " " $3 " " $6 " " $7 " " $8 " " $9}' file

awk '{$4=" "; $5=" "; print}' file

Is this what you were looking for?
This User Gave Thanks to juzz4fun For This Post:
expert
# 5  
Old 05-08-2013
Quote:
Originally Posted by expert
i need to remove from the column 54 to 70 , as like the below output.

Please elaborate. The strings you want to remove are not column 54 to 70.
# 6  
Old 05-08-2013
Your example text did not appear to have 70+ columns. My count showed 56 characters across.
# 7  
Old 05-08-2013
Quote:
Originally Posted by juzz4fun

awk '{print $1 " " $2 " " $3 " " $6 " " $7 " " $8 " " $9}' file
Since the default value of OFS is a space, you do not need to explicitly concatenate.
Code:
print $1, $2, $3, $6, $7, $8, $9

Regards,
Alister
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Remove non printing characters from file

How do I remove the printer escape sequence, the first 5 characters, that occurs on every 33rd line in a file, see hex dump of line 1. 0000 1e 00 00 00 00 0a 0a 0a 20 0a 20 20 20 20 20 20 .... 0010 20 20 20 20 20 20 20 20 20 20 0a 42 49 4c 4c 20 Thanks, (2 Replies)
Discussion started by: jgt
2 Replies

2. Shell Programming and Scripting

how to remove the non : characters after the password in shadow file?

On SPARC Solaris 10. I set the app account so it's expired. I also want it so not required to change password at first login, I can do this by removing the numbers after the password in /etc/shadow. example using user1 The /etc/shadow file looks like this: user1:kOmcVXAImRTAY:0::::90:: ... (8 Replies)
Discussion started by: TKD
8 Replies

3. Shell Programming and Scripting

Remove characters from fixed length file

Hello I've question on the requirement I am working on. We are getting a fixed length file with "33" characters long. We are processing that file loading into DB. Now some times we are getting a file with "35" characters long. In this case I have to remove two characters (in 22,23... (14 Replies)
Discussion started by: manasvi24
14 Replies

4. UNIX Desktop Questions & Answers

Remove new line characters from a file

I tried using below command tr -cd "" < InputFile.xml > output.txt ============= This removes all the tabs/newline/extra spaces from a file it successfully removed all the extra spaces,tabs and new line characters but then the complete file become one record. I want to retain one new line... (1 Reply)
Discussion started by: saini
1 Replies

5. Shell Programming and Scripting

Remove the characters from the file

Hi, I have one file in the following format. exa_resu_adj.4ge v.47645 PERSONAL INFORMAIONS PVT LTD 31 Dec 2009 04:36 Page 1 SALARY REPORT Account Account Name CCode Bill No Balance T Amt ----------- ------------ ------- ---------- ------------- ------------- 17490001 Mr Ram PM 10... (6 Replies)
Discussion started by: Kattoor
6 Replies

6. Shell Programming and Scripting

How to remove ^M characters from a zip file?

Hi All, As all of us know that while moving a file from Windows to Unix some unwanted ^M characters appear in the file. For my case I have release package in zip format which looks like Module_Name_Tag.zip. It contains some directory structure...like Module_Name_Tag.zip | |--trunk/... (2 Replies)
Discussion started by: bhaskar_m
2 Replies

7. Shell Programming and Scripting

Trying to remove '^M' characters from a file.

Hi guys, Hope you are all well. This is a line of data from a csv file. I have used vi and set the 'set list' option to display the trailing $ character. "01","Grocery","01006","eat Fish & Spreads"$ I have tried the following commands, but neither of them appear to be working? 1) tr... (13 Replies)
Discussion started by: Krispy
13 Replies

8. Shell Programming and Scripting

Remove characters from file name

Here is my code. for file in *1.3.html ; do mv "$file" `echo $file | tr '.1.3' ''` ; done For some reason I am getting an error. mv: file.idlesince.1.3.html and file.idlesince.1.3.html are identical Could this be done a different way? (5 Replies)
Discussion started by: mrlayance
5 Replies

9. Shell Programming and Scripting

sed to remove last 2 characters of txt file

sed 's/^..//' file1.txt > file2.txt this will remove the first two characters of each line of a text file, what sed command will remove the last two characters? This is a similar post to my other....sry if I'm being lazy.... I need a file like this (same as last post) >cat file1.txt 10081551... (1 Reply)
Discussion started by: ajp7701
1 Replies

10. UNIX for Dummies Questions & Answers

How to remove null characters from file?

I'm trying to remove the null characters from a file and copy it to std output. I'm using emacs and I create the following one line bash file (followed by the error messages): sed -e 's/^@//' <ConfigItemReplicator.install.log /usr/bin/bash: -c: line 0: unexpected EOF while looking for... (1 Reply)
Discussion started by: siegfried
1 Replies
Login or Register to Ask a Question