Search for string and replace with another

Question

I have data with one of the column as

         Activity Description             
   --------------------------------------------- 
       Handling &  PNR Movement Charges-FCL        
       Value Added Charges                         
       Container Tracking Charges-FCL              
       Contrainer Ground Rent Charges-FCL          
       Documentation Charges FCL                   
       Insurance Charges-FCL                       
       Seal Charges                                
       Fuel Charges-FCL                            
       Container Movement and Increase Charges-FCL 
       Weighment Charges-FCL                       
       Container Movement and Increase Charges-FCL

I need to search for string which contains "FCL" and replace the word without FCL. Ex. Insurance charges-FCL to Insurance charges i.e I dont need the string FCL.

I tried with below code,

 for (line in file_read$`Activity Description`){
 if (line == "*FCL"){
 new_column <- c(new_column,"*")

It is not working.

Is my code right or I need to change with another script of code?

Can anyone help me on this?

Can you show a larger data set? Does `FCL` always occur at the end of the string, preceded by a dash? — Tim Biegeleisen, Oct 24 '18 at 07:48
Does that really work? Wouldn't it leave behind dashes in your names? — Tim Biegeleisen, Oct 24 '18 at 07:52
@TimBiegeleisen, It prints with dashes, but how can I remove the dashes, but string has dashes and another string doesn't — krishna31, Oct 24 '18 at 07:54
Please answer my earlier comment. Show sample data which covers _all_ the types of descriptions where `FCL` can appear. Then, someone can give you a more exact answer. — Tim Biegeleisen, Oct 24 '18 at 07:54

score 1 · Accepted Answer · answered Oct 24 '18 at 07:57

1

Assuming that FCL would always occur at the end of your descriptions, preceded by a dash, space, or some other non alphanumeric character, then here is a safe way to do the replacement using sub:

df$`Activity Description` <- sub("[^[:alnum:]]FCL$", "", df$`Activity Description`)

answered Oct 24 '18 at 07:57

Tim Biegeleisen

502,043
27
286
360

Thanks It is working, but how can remove the dashes if dashes present with string named FCL? – krishna31 Oct 24 '18 at 08:01
This would replace `-FCL` with empty string. Not sure what you are asking. For the third time, please update your question with complete sample data. – Tim Biegeleisen Oct 24 '18 at 08:02
Thanks, it works, I didnt properly check. – krishna31 Oct 24 '18 at 08:08

Search for string and replace with another

1 Answers1