header1   header
header
header : : Login header
header
connector   connector
menuleft menuright
submenu   submenu
left
IMPORTANT: PowerShellCommunity.org is moving! - Wednesday, August 15, 2012

PowerShellCommunity.org is moving!  This community software, and the hardware that it sits on, are no longer serving the purposes of this community.  As a result, we have decided to move this community to a new home at PowerShell.org.  PowerShell.org is already up and running with the new community software and in its new location, so please post any new questions that you have on the forums over there instead of posting them on this site.  We've already started getting some great questions from members of the community over there so please, come on over and join us!

While we are going through this transition, this site will remain up for the short term.  New posts may no longer be created on these forums, however replies to existing posts are allowed so that users who posted questions don't have to re-post the same question on the new site.

[UPDATE 28/02/2013] New user registration has been disabled and forums have now been switched to read-only, including for existing posts since all threads that were started should now be completed. If you have a question about content on this site or about PowerShell in general, head over to PowerShell.org and ask it there where there are people actively using the site and answering questions.

If you have any questions, please let us know on the PowerShell.org site.

Thank you,

Kirk "Poshoholic" Munro

 
Converting a multiline string into a single line string
Last Post 21 Mar 2012 07:32 AM by EdShep. 0 Replies.
Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
EdShepUser is Offline
New Member
New Member
Posts:3
Avatar

--
21 Mar 2012 07:32 AM
    Hi all,

    We are developing a new call logging system and I have been tasked to try and sort out an engineer report using powershell...

    The problem I am having is that the call logs can be updated by email and when I pull this information out of the database with powershell, it is returned to me with carrage returns.

    an example is an email that says:

    Ed,

    gubbins gubbins, blah blah.

    more gubbins, blah!

    Kind regards

    Mr BlowMonkey
    technical numpty
    over there



    once its gone into and through the system and I run my script.... returns

    EnteredDate   EnterdBy   Comment
    ------------  ---------   ---------
    21/03/03       Ed Shep    Ed, 

                                      gubbins gubbins, blah blah. 
                               
                                      more gubbins, blah! 

                                      Kind regards 

                                      Mr BlowMonkey 
                                      technical numpty
                                      over there

    What I would like is somtehing like this...

    EnteredDate      EnterdBy     Comment
    ------------     ---------     ---------
    21/03/03          Ed Shep       Ed, gubbins gubbins, blah blah. more gubbins, blah! Kind regards Mr BlowMonkey technical numpty over there

    What this would allow me to do is to sort all the entries by the EnteredDate, which I can do at the moment, but the sorting only takes with it the line containing the date, instead of the entire array row, which is how I was hoping / expecting it to work.
     

    Any Ideas, greatly recieved

    Thank in advance,

    Ed
    You are not authorized to post a reply.


    Active Forums 4.3
    right
    footer   footer
    footer Many thanks to our original sponsors: Quest Software • SAPIEN Technologies • Compellent • Microsoft footer
    footer   footer