extracting a date from a text file using sed

[ljungers]

Help needed with shell script using the sed command.
Need to extract a date from a text file. Each record contains the text "Date Entered:" and following that literial is a space followed by mm/dd/yyyy and two spaces. There are occasions when the literal is present with no date, just 3 spaces following it.

I need to extract that date and place it in a variable so that it may be used when writing out that record to a new file. There are other variables being extracted but the date is what I am having problems with. I am creating a tab delimited file that will be used as a table load in a SQL database.

Anyone know how to use sed to do this, the script already exist I just need to add the correct code to this script.

Thanks for any help.

[Motoma]

Help needed with shell script using the sed command.
Need to extract a date from a text file. Each record contains the text "Date Entered:" and following that literial is a space followed by mm/dd/yyyy and two spaces. There are occasions when the literal is present with no date, just 3 spaces following it.

I need to extract that date and place it in a variable so that it may be used when writing out that record to a new file. There are other variables being extracted but the date is what I am having problems with. I am creating a tab delimited file that will be used as a table load in a SQL database.

Anyone know how to use sed to do this, the script already exist I just need to add the correct code to this script.

Thanks for any help.

sed 's/\(.\) \([0-9]\{2\}\/[0-9]\{2\}\/[0-9]\{4\}\) \(.\)/\2/'