Date conversion

[RAJAPPA]

My data contains data in the format "20191102"
How can I convert them to
" 02/11/2016 "

[neil butterworth]

> How can I convert them to " 02/11/2016 "

Do you actually mean "02/11/2019"?

--
You received this message because you are subscribed to the Google Groups "csvfix" group.
To unsubscribe from this group and stop receiving emails from it, send an email to csvfix+unsubscribe@googlegroups.com.
To post to this group, send email to csv...@googlegroups.com.
Visit this group at https://groups.google.com/group/csvfix.
For more options, visit https://groups.google.com/d/optout.

[RAJAPPA]

I am extremely sorry
Given value 20161102
To be formated 02/11/2016

[Neil Butterworth]

[neilb@cordelia temp]$ cat d.csv
20161102

[neilb@cordelia temp]$ csvfix edit -e "s:\(....\)\(..\)\(..\):\3/\2/\1:" d.csv
"02/11/2016"

Also, you spammed this group with 14 copies of basically the same post - don't do that again, or you will be banned.

[RAJAPPA]

Sorry sir
Thanks a lot
Which portion of the help file /topic should I read in order to write code like this in future

[Neil Butterworth]

You need to read upon regular expressions - there is no tutorial material on these in the CSVfix manual.