viewpoint-particle

Author Topic: Text to columns  (Read 103 times)

MW4

  • Full Member
  • ***
  • Posts: 173
Text to columns
« on: October 02, 2019, 10:28:38 am »
what is the easiest approach to take this example line of text (broken by spaces):

JEFFERSON 71 443317 1CZZJFAG7LC148605 L-WKJ-4434202

To end with this
Field1: JEFFERSON
Field2: 71
Field3: 443317
Field4: 1CZZJFAG7LC148605
Field5: L-WKJ-4434202

I know it has to do with finding the location of the space, but in looking around this morning, I can't seem to find it.
Can someone help with a point in the right direction?

Time for some Bulletproof Coffee, LOL

kdmoyers

  • Sr. Member
  • ****
  • Posts: 291
Re: Text to columns
« Reply #1 on: October 02, 2019, 11:17:52 am »
Take a look at ItemExtract

-Kirby
The mind is everything; What you think, you become.

MW4

  • Full Member
  • ***
  • Posts: 173
Re: Text to columns
« Reply #2 on: October 02, 2019, 04:11:42 pm »
Thanks!!!