Text to columns

Started by MW4, October 02, 2019, 10:28:38 AM

Previous topic - Next topic

MW4

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

Take a look at ItemExtract

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

MW4