0

I have following file:

./foldername/company_users_policies_changes.txt
"terraform_automated_python","AdministratorAccess"
./foldername/company_groups_policies.txt
"terraform_automated_python","ec2fullacess"
 ........................................

I want to leave only filenames not full path (remove everything except filename only)

Desired output:

 company_users_policies_changes
"terraform_automated_python","AdministratorAccess"
company_groups_policies
"terraform_automated_python","ec2fullacess"
 ........................................
Milister
  • 101

2 Answers2

1

Your first line in the desired output contains a leading space but I assume that is simply a transcription error.

The following will find ./foldername/ at the beginning of line, and replace it with nothing, and similarly replace .txt at the end of a line with nothing.

sed -i 's%^\./foldername/%%;s/\.txt$//' filename

The -i option says to modify the file "in-place" (i.e. replace the original file with the edited file). On some platforms (notably *BSD, and thus also MacOS) you need an option -i '' which can be empty to say you don't want a backup file to be created (or give it something like -i ~ to save the original file as filename~).

It is not hard to combine the two actions into a single regex if you want to make sure they only occur when both conditions are true (though this complicates matters slightly in that you need to understand how to use a back reference); 

sed -i 's%^\./foldername/\(.*\)\.txt$/\1/' filename

or you can add a conditional to the script to abandon the second action if the first does not succeed.

tripleee
  • 3,308
  • 5
  • 36
  • 35
-1
cat changes.txt | awk -F/ '{print $NF}' | sed -e 's/.txt\/$//' | sed -e 's/.txt//'

Output:

changes
 group_policies_changes
aaaaaaaaaa
 role_assignemnt_changes
"ec2ssmMaintWindow","AmazonSSMMaintenanceWindowRole","ssm.amazonaws.com--ec2.amazonaws.com"
"ec2ssmRole","AmazonEC2RoleforSSM--AmazonSSMFullAccess","ssm.amazonaws.com--ec2.amazonaws.com"
 users_policies_changes
"terraform_automated_python","AdministratorAccess"
Milister
  • 101