Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

- JMP User Community
- :
- Discussions
- :
- Parsing Datetime with symbols

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

Highlighted

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Aug 13, 2020 9:26 AM
(288 views)

Dear community:

I am having trouble to find a good solution to parse Datetime examples below by changing the "Format" (under "Column Info"):

2018-01-01 14:44:19.290000+00:00

2018-01-01 13:43:40.090000+00:00

Currently, I have to use Regex to find the pattern after the period and then replace it with blank. I am hoping that there is an easy option.

Thank you for your help!

1 ACCEPTED SOLUTION

Accepted Solutions

Highlighted

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

I don't know if this result is quite what you want but it is simple.

I used this formula in another column and left the original alone.

`Informat( Substitute( Word( 1, :Date Time String, "+" ), " ", "T" ), "yyy-mm-dd" )`

Learn it once, use it forever!

3 REPLIES 3

Highlighted
##

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Re: Parsing Datetime with symbols

Again, my favorite function comes the rescue.

Read more about these two topics:

If you learn only one Formula Editor function, Word() is the one

Using dates, times, datetimes and durations in JMP

-Jeff

Highlighted

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

I don't know if this result is quite what you want but it is simple.

I used this formula in another column and left the original alone.

`Informat( Substitute( Word( 1, :Date Time String, "+" ), " ", "T" ), "yyy-mm-dd" )`

Learn it once, use it forever!

Highlighted
##

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Re: Parsing Datetime with symbols

The T format is really useful for exchanging date time values, even if it is a bit ugly.

https://en.wikipedia.org/wiki/ISO_8601#Combined_date_and_time_representations

Craige

Article Labels

There are no labels assigned to this post.