How to take only the date out of columns and copy the date to another column with another format of the date?
Fulachs
The script should take the date out of column B and only cope the date to D and format it to european date format. Is this possible to do?
user6655984
There's no need to use a script for this. The regexextract function can extract the date, which can then be recombined into whatever format. It's best to use three helper columns, which may be hidden (say, X, Y, Z). In X2, put
=regexextract(B2, "(\d{2})/(\d{2})/(\d{4})")
This will place the month, date, and year in cells X2, Y2, Z2. Then in D2, put
=Y2 & "." & X2 & "." & Z2
and you are done.
This also works in arrayformula mode, handling the entire column at once:
=iferror(arrayformula(regexextract(B2:B, "(\d{2})/(\d{2})/(\d{4})")))
where iferror suppresses error from cells that don't contain a date.
After that,
=arrayformula(if(len(Z2:Z), Y2:Y & "." & X2:X & "." & Z2:Z, ))
recombines the date, again leaving blanks where no date was parsed out.
Collected from the Internet
Please contact [email protected] to delete if infringement.
edited at
- Prev: var dump not working for a particular php file
- Next: ggplot2: Add legend and associated legend title to barplot
Related
Related Related
- 1
How can I convert a date into another format with moment.js?
- 2
Convert date string to another format date string in pandas
- 3
Is there a way to copy Date object into another date Object without using a reference?
- 4
How to convert date with suffix to another format in python
- 5
How to convert String date into another date format in SQL server?
- 6
How to change date format for the date column in datatable?
- 7
How to validate that date in future in reference to another date?
- 8
How do I copy a date from one variable to another in R data.table without losing the date format?
- 9
How to add another column's integer value to a date column?
- 10
Format date into another format return wrong date
- 11
How to Format a Date Column in Pandas?
- 12
How to compare today date with another date in javascript?
- 13
How to Convert Date(from date time input field) to another date format in C#?
- 14
Adapt a date string into another format
- 15
Convert Date with milliseconds to another date format
- 16
how can I take the date out, put it in another field and leave the time?
- 17
How to concatenate date and time columns based on value from another column in sql?
- 18
Format string with date by javascript to another format
- 19
Convert Date to another format
- 20
IOS how to compare date with another date?
- 21
How can I make Excel copy my formatted date to another window and keep the format when some dates are full and some are only the year
- 22
How can I convert a date format to another date format in Swift?
- 23
How to convert one date format to another format using angular JS?
- 24
Convert one format of date to another format using perl Date::Manip
- 25
How to convert a binary date column date into gregorian date format in sql
- 26
Convert timestamp into another date format
- 27
How to create date with date and time and then compare it to another date
- 28
Get Max date by another column
- 29
How do I take string date input and convert it into another format?
Comments