split string field into multiple records.

LastDate04/16/1804/23/18LastTime5327834142LastUserTGIBBRMPCOMHERRRMPCOPkgcode26

Need to split the above string field into multiple records:

LastDate 04/16/18 04/23/18
LastTime 53278 34142
LastUser TGIBBRMPCO MHERRRMPCO
Pkgcode  26
Tricia WhitedDP ManagerAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Ido MilletProfessor of MIS at Penn State Erie and Owner, Millet SoftwareCommented:
Replace({YourField},"",CHR(10))

Open in new window

0
Tricia WhitedDP ManagerAuthor Commented:
I t works. Thanks so much.
0
Tricia WhitedDP ManagerAuthor Commented:
Is there a way to actually make separate fields of this string field?
0
Introducing Cloud Class® training courses

Tech changes fast. You can learn faster. That’s why we’re bringing professional training courses to Experts Exchange. With a subscription, you can access all the Cloud Class® courses to expand your education, prep for certifications, and get top-notch instructions.

Ido MilletProfessor of MIS at Penn State Erie and Owner, Millet SoftwareCommented:
You can create formulas for return the 1st, 2nd, 3rd element by using something like:
Split({YourField},"")[1]

Open in new window

Split converts the string to an array and [1] indicates you want just the 1st element in the array.
0
Tricia WhitedDP ManagerAuthor Commented:
Thank you.
0
James0628Commented:
I'm getting to this late, but, for anyone else that might look at this question, I wanted to point out that there are some "non-display" characters in the string in the first post.  In particular, there is a specific character (ChrW (3)) in between the strings that the OP wanted separated.  It might depend on your Web browser or system settings, but, in my case, those characters didn't appear at all in the posts here, so I didn't see how the suggested solution could possibly work (because it appeared to be replacing nothing with a Carriage Return).

 I'm not looking for any points.  I just wanted to try to save others from being confused like I was.  :-)

 James
0
Tricia WhitedDP ManagerAuthor Commented:
This is what the field looked like in Crystal before any changes:

LastDate05/18/1707/15/17LastTime3851333165LastUserPWALM188TKIRKRMPCOStopcodeDPP

Then using the above suggestion: Replace({ChangeLog21.FieldList},"",CHR(10))

it now looks like this:
LastDate05/18/1707/15/17
LastTime3851333165
LastUserPWALM188TKIRKRMPCO
StopcodeDPP

I then used this formula: Replace({@split},"",CHRw(9))
Now it looks like this:

LastDate      05/18/17      07/15/17
LastTime      38513      33165
LastUser      PWALM188      TKIRKRMPCO
Stopcode      D      PP

This is how I wanted the field to look.
 
Thanks for all your help.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Crystal Reports

From novice to tech pro — start learning today.