Text to column
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Raghadhq
7 - Meteor
‎12-24-2023
04:04 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi there,
i have problem in splitting the column in the file attached as it won't split the date and time in different column.
Thanks
Labels:
- Labels:
- Designer Cloud
3 REPLIES 3
TimN
13 - Pulsar
‎12-24-2023
05:43 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
rzdodson
12 - Quasar
‎12-26-2023
07:43 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@Raghadhq adding three more potential solutions for you based on scenarios I can think of. Appended below is a screenshot of the third method using Regex_Replace inside of a Multi-Field Formula to clean the time-related fields you are targeting.
nagakavyasri
12 - Quasar
‎12-26-2023
01:52 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
