How to change date format in sed?

by

e switch in sed substitute applies sh -c to unmatched text as well as evident from this command:

echo 'a 1449158360' | sed -r 's#([0-9]{10})#date -d@\1 "+%Y";#e'
sh: a: command not found

So even though we are matching only 1449158360 but sh -c is being run on a 1449158360.

Due to absence of non-greedy and lookaheads regex in sed this workaround regex might appear crazy but this is how you can run it for multiple matching input from file as in your question:

sed -r 's#(([^0-9][0-9]{0,9})*)(\b[0-9]{10}\b)(([0-9]{0,9}[^0-9])*)#printf "%s%s%s" "\1" $(date -d@\3 "+%Y") "\4";#ge' file

Basically we are matching <before>10-digits<after> in this regex.

Output:

my timestamp is 2015 but also I wonder what date was 2013.

To clarify the regex used I have created this demo.

By no means this is a generic solution to e mode issue, treat it as a regex based workaround.

More Related Contents:

  1. RE error: illegal byte sequence on Mac OS X
  2. How to extract text from a string using sed?
  3. Why is sed not recognizing \t as a tab?
  4. Insert linefeed in sed (Mac OS X)
  5. Replace a word with multiple lines using sed?
  6. replace a unknown string between two known strings with sed
  7. Awk – replace coumn 2 in table 1 from coumn 2 in table 2 based on matching data in column 1 (common between tables)
  8. Regular Expression to match valid dates
  9. Bash Regular Expression — Can’t seem to match any of \s \S \d \D \w \W etc
  10. Using sed to delete all lines between two matching patterns
  11. How to match digits in regex in bash script
  12. Why doesn’t `\d` work in regular expressions in sed? [duplicate]
  13. sed one-liner to convert all uppercase to lowercase?
  14. Bash, grep between two lines with specified string
  15. Fully qualified domain name validation
  16. sed join lines together
  17. How to replace a whole line with sed?
  18. What does ‘\K’ mean in this regex?
  19. Does bash support word boundary regular expressions?
  20. Replace newlines with literal \n
  21. Remove duplicates from text file based on second text file
  22. How to match a pattern given in a variable in awk?
  23. How can I match a string with a regex in Bash?
  24. Why does sed require 3 backslashes for a regular backslash?
  25. Rename files using a regex with bash [duplicate]
  26. How can I match spaces with a regexp in Bash?
  27. How to execute a Bash command only if a Docker container with a given name does not exist?
  28. Bash – Regex for HTML contents
  29. How to extract domain name from url?
  30. Whats the difference between sed -E and sed -e

Leave a Comment