I have the following CSV file as input
sample1 compute.googleapis.com/projects/project_ID1/zones/europe-west2-a test1
sample1 compute.googleapis.com/projects/project_ID2/zones/europe-west2-a test2
sample1 compute.googleapis.com/projects/project_ID3/zones/europe-west2-a test3
How I can use a shell command to extract project ID from column 2 of the above file and save it as CSV as shown below enter code here
sample1 project_ID1 test1
sample1 project_ID2 test2
sample1 project_ID3 test3
Thanks Ajit
CodePudding user response:
Wit awk:
$ awk -F '[/ ]' '{print $1, $4, $7}' FILE
sample1 project_ID1 test1
sample1 project_ID2 test2
sample1 project_ID3 test3
CodePudding user response:
Little bit of modification to above @Arkadiusz Drabczyk solution would give comma separated data
Code :
awk -F '[/ ]' '{print $1 "," $4 "," $7}' demo.txt
Expected Output :
sample1,project_ID1,test1
sample1,project_ID2,test2
sample1,project_ID3,test3
You can write the above data to new file using below command
awk -F '[/ ]' '{print $1 "," $4 "," $7}' demo.txt >> demo.csv