Hi Experts,
I really need your URGENT help with one requirement. Please help ASAP.
So, basically I have all user's comments within a string. String Example:
2023-07-23 09:19:38 - System Administrator (Additional comments)
requesting the new update frp, powerapps
2023-02-20 10:05:40 - glide.maint (Additional comments)
Exchange server unavailable. Ping does not respond, and lots of
users calling in about it looks to be San
Diego, building 3, floor 4
that's affected.
Now, what I want is I want to store these details within a collection but before doing that I want to manipulate and refine the string like it should be something like this:
Date - useranme (Additional Comments)
UserComments
For Example:
The table should consist of 2 columns:
Date - username (additional comments)
Comments
See Below, If I take the 2nd user comments from the top comments list:
2023-02-20 10:05:40 - glide.maint (Additional comments)
Exchange server unavailable. Ping does not respond, and lots of
users calling in about it looks to be San
Diego, building 3, floor 4
that's affected.
It should first store 2023-02-20 10:05:40 - glide.maint (Additional comments) which is a first linen Column 1 and then the second line with removing all the line breaks and trimmed in Column 2 as Exchange server unavailable. Ping does not respond, and lots of users calling in about it looks to be SanDiego, building 3, floor 4 that's affected.
Hope you understood the requirement. Please help. I am in urgent need for the resolution.
