I have strings:
fvvDataFolders/DDB/DDB2018-02-21oM]
fbbDataFolders/DDB/DDB2018-02-22oM]
I want to strip everything that starts with Data and ends in what looks like a date:
DataFolders/DDB/DDB2018-02-21
DataFolders/DDC/DDB2018-02-22
How I can do it?
Either
grep -P -o 'Data.+?dddd-dd-dd'
or
perl -pe 's/^.+(Data.+?dddd-dd-dd).+$/$1/'
will do. They both print the minimal string that starts with Data and ends in what looks like a date (YYYY-MM-DD).
echo "fvvDataFolders/DDB/DDB2018-02-21oM]" > input.txt
echo "fbbDataFolders/DDB/DDB2018-02-22oM]" >> input.txt
grep -P -o 'Data.+?dddd-dd-dd' input.txt
# output:
DataFolders/DDB/DDB2018-02-21
DataFolders/DDB/DDB2018-02-22
perl -pe 's/^.+(Data.+?dddd-dd-dd).+$/$1/' input.txt
# output:
DataFolders/DDB/DDB2018-02-21
DataFolders/DDB/DDB2018-02-22
