Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

String removal from file

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting String removal from file
# 1  
Old 01-10-2014
String removal from file
Dear all

From below mention input file I needed op file as show below. I am using below code but not worked.


I/p file
Code:
BSCBCH1 EXAL-1-4     WO*     SMPS MAINS FAIL
BSCBCH1 EXAL-1-5     WO*     SMPS RECTIFIER FAIL 
BSCBCH1 EXAL-1-6     WO*    SMPS MAJOR ALARM 
BSCBCH2 EXAL-1-10    WO*    AC2 UNIT FAIL 
BSCBCH2 EXAL-1-14    WO*    AC1 UNIT FAIL

o/p file:
Code:
BSCBCH1  SMPS MAINS FAIL
BSCBCH1  SMPS RECTIFIER FAIL 
BSCBCH1  SMPS MAJOR ALARM 
BSCBCH2  AC2 UNIT FAIL 
BSCBCH2  AC1 UNIT FAIL

below code not worked:

Code:
awk '{a=$1} /WO/ {b=$4} {print a b}' finename.txt

Thanks in advance.

Regards
Jaydeep
# 2  
Old 01-10-2014
because you have not displayed the other fields...
Code:
awk '{a=$1} /WO/ {b=" "$4" " $5" " $6} {print a b}' filename.txt

# 3  
Old 01-10-2014
Not necessary to use variables, this should be sufficient:
Code:
awk '/WO/ {print $1, $4, $5, $6}' filename.txt

# 4  
Old 01-10-2014
Given that your file appears to be fixed-width format rather than delimited, it might be easier (and safer) to just use cut.
# 5  
Old 01-10-2014
Code:
awk 'sub(/ .*WO\* */," ")' file

# 6  
Old 01-28-2014
Hello All,

Some more approaches.

Code:
sed 's/\(.*\)\(\ WO\* \)\(.*\)/\1\3/g' file_name
 
awk '/WO\*/ {print $1OFS$2OFS$4}' file_name
 
awk '/WO\*/ gsub(/ WO\* /,X,$0) {print}' file_name



Thanks,
R. Singh
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Removing string from CSV file by provide removal string from other file

What I need is to remove the text from Location_file.txt from each line matching all entries from Remove_location.txt Location_file.txt FlowPrePaid, h3nmg1cm2,Jamaica_MTAImageFileFlowPrePaid,h0nmg1cm1, Flow_BeatTest,FlowRockTest FlowNewTest,FlowNewTest,h0nmg1cm1 PartiallySubscribed,... (3 Replies)
Discussion started by: ketanraut
3 Replies

2. UNIX for Dummies Questions & Answers

awk string removal

Hi, I am trying to remove a string ".var" using the below command but it's not working as expected, when I execute this in the command prompt using the echo it's working fine , please let me know where I am doing it wrong. UYRD=$FILE_$timestamp.csv | awk '{gsub(".var", "");print}' # this is... (6 Replies)
Discussion started by: shruthidwh
6 Replies

3. Solaris

Removal of zip file permanently

Hi Everyone, I see some peculier thing happening on my server. I have one zipped file created long back as a normal user and trying to remove it now. When i tried to remove as that particular user, i was not able to do that. So i logged in as a root user and removed that successfully. But it... (8 Replies)
Discussion started by: Sricharan21
8 Replies

4. Programming

Fast string removal from large text collection

Hi All, I don't want any codes for this problem. Just suggestions: I have a huge collection of text files (around 300,000) which look like this: 1.fil orange apple dskjdsk computer skjks The entire text collection (referenced above) has about 1 billion words. I have created... (1 Reply)
Discussion started by: shoaibjameel123
1 Replies

5. Shell Programming and Scripting

Help with removal of numericals in a file

I have a file from which I want to eliminate the numerical values.. The contents of the file are as shown below.. 1 a1,b,2 1,b,c 2 a2,4,b a,b,2 From the above file I want eliminate only the numberical values(except the line numbers which are at the beginning).. The file... (12 Replies)
Discussion started by: abk07
12 Replies

6. Shell Programming and Scripting

Help with removal of blank spaces in a file

Hello.. I have a text file. I want to remove all the blank spaces(except tab) from the file.. I tried using sed command as shown below sed 's/ //g' file1 But the problem with the above command is that it also eliminates 'tab' which is between the columns.. For example if the contents... (7 Replies)
Discussion started by: abk07
7 Replies

7. Shell Programming and Scripting

Removal of file extension question

All, I know that this will remove a file extension from a file name, but reading on the documentation on how it works confuses me. ${filename%.*}Can anyone explain what exactly is going on here? Filename is the pattern and % says to cut anything that starts with .? Also, can I run this... (4 Replies)
Discussion started by: markdjones82
4 Replies

8. UNIX for Dummies Questions & Answers

selective removal of blank spaces in string

Hi, I'm a newbie to shell scripting and I have the following problem: I need all spaces between two letters or a letter and a number exchanged for an underscore, but all spaces between a letter and other characters need to remain. Searching forums didn't help... One example for clarity: ... (3 Replies)
Discussion started by: Cpt_Cell
3 Replies

9. Shell Programming and Scripting

Removal of Duplicate Entries from the file

I have a file which consists of 1000 entries. Out of 1000 entries i have 500 Duplicate Entires. I want to remove the first Duplicate Entry (i,e entire Line) in the File. The example of the File is shown below: 8244100010143276|MARISOL CARO||MORALES|HSD768|CARR 430 KM 1.7 ... (1 Reply)
Discussion started by: ravi_rn
1 Replies

10. Solaris

UNIX File removal without conformation

I need to remove permanently some 3 GB of temp folder which contains Log file, simulation files from my disk. if i use "rm - rf <filename>" command it asks about conformation for accessing each folder and for removing every file and giving yes to every message in terminal window is very... (2 Replies)
Discussion started by: rajharvijay
2 Replies
Login or Register to Ask a Question