How to split RSS date entry

Hi! I would like to order multiple RSS feeds on date, but can’t figure out how to do it automated.
The date given by the RSS feed is text, for example, “Fri, 15 Feb 2019 11:00:00 +0100”
The pattern always repeats itself:
[day], [date] [month] [YYYY] [HH:mm:ss] [Time Zone offset]

I only need [date] [month] [YYYY] in order [YYYY] [month] [date] (2019/10/02)

made a sample sheet with some not working formulas…

Thanks in advance

Darn that was a challenging. It has got to be one of the most complex formulas I have ever written in a while.

Plug this into F2 of your rss sheet:

=ARRAYFORMULA(IF(A2:A<>"";
              DATEVALUE(INDEX(SPLIT(A2:A;" ");0;2) &
              "/" &
              ((FIND(INDEX(SPLIT(A2:A;" ");0;3);"JanFebMarAprMayJunJulAugSepOctNovDec")-1)/3)+1 &
              "/" &
              INDEX(SPLIT(A2:A;" ");0;4));
              "")
             )
3 Likes

wow! This works perfectly. Thank you soooo much @George_B! it’s a pretty impressive formula indeed! don’t know if I got it working without your help. Thanks again.

ps. the semicolon is a mystery for me too.

1 Like

@George_B :wave:I found a funny thing.
when in Glide selecting inline list and refer to the column with the formula, Glide shows a number!
Glide does not recognize in title, description or caption the date format given in the spreadsheet.
I don’t need it, was just testing. but would be a nice feature… for in the caption though. Thanks again!

I guess you could always format it as text in another column if you did want to display it. something like =TEXT(C6,“mm/dd/yyy”)

1 Like