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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Tricia WhitedDP ManagerAuthor Commented:
I t works. Thanks so much.
Tricia WhitedDP ManagerAuthor Commented:
Is there a way to actually make separate fields of this string field?
Exploring SharePoint 2016

Explore SharePoint 2016, the web-based, collaborative platform that integrates with Microsoft Office to provide intranets, secure document management, and collaboration so you can develop your online and offline capabilities.

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.
Tricia WhitedDP ManagerAuthor Commented:
Thank you.
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
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.
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.