HockeyDiablo
Board Regular
- Joined
- Apr 1, 2016
- Messages
- 182
I have a large string of text that was a former "Note" Field.
I have various dates within. Is there a way to delimit that string of text similar to how the Text to Columns feature works? But instead of by , "comma" you can use a date?
Thanks guys
Here is a sample of what I have:
01/01/2016 12:00 Happy New Years. 02/02/2016 Is groundhog day. 03/15/2016 Today will be ran by hotcode 24. After you should run hotcode25. 04/04/2016 The account was closed, several delinquents.
Here is what I would like it to output: [Column]
[01/01/2016 12:00 Happy New Years.] [02/02/2016 Is groundhog day.] [03/15/2016 Today will be ran by hotcode 24. After you should run hotcode25.] [04/04/2016 The account was closed, several delinquents.]
I have various dates within. Is there a way to delimit that string of text similar to how the Text to Columns feature works? But instead of by , "comma" you can use a date?
Thanks guys
Here is a sample of what I have:
01/01/2016 12:00 Happy New Years. 02/02/2016 Is groundhog day. 03/15/2016 Today will be ran by hotcode 24. After you should run hotcode25. 04/04/2016 The account was closed, several delinquents.
Here is what I would like it to output: [Column]
[01/01/2016 12:00 Happy New Years.] [02/02/2016 Is groundhog day.] [03/15/2016 Today will be ran by hotcode 24. After you should run hotcode25.] [04/04/2016 The account was closed, several delinquents.]
Last edited: