Copying Text from Bluebeam

  • Copying Text from Bluebeam

    Posted by Matt Hackman on July 6, 2022 at 2:05 pm

    When copying text from Bluebeam that has multiple lines and pasting somewhere else, the paste will keep the line returns precisely as shown in Bluebeam and I will need to delete the return and add a space to get the text formatted into my excel/word file. Is there a tip/fix for this?

    Troy DeGroot replied 1 month, 1 week ago 4 Members · 6 Replies
  • 6 Replies
  • Vince

    Member
    July 6, 2022 at 2:22 pm
    Points: 4,907
    Rank: UC2 Brainery Orange Belt IIII UC2 Brainery Orange Belt IIII

    If you paste into Excel you can then use the ‘Textjoin’ function to create a single line then delete the original text e.g. if you have copied & pasted from Bluebeam and you have text in cells A1 to A9 then use

    =TEXTJOIN(” “,,A1:A9)

    • Matt Hackman

      Member
      July 6, 2022 at 2:35 pm
      Points: 1,640
      Rank: UC2 Brainery Yellow Belt II UC2 Brainery Yellow Belt II

      Awesome thank you.

      What about if I pasted it all into a single cell and it retains all the returns?

      • Vince

        Member
        July 6, 2022 at 2:39 pm
        Points: 4,907
        Rank: UC2 Brainery Orange Belt IIII UC2 Brainery Orange Belt IIII

        Try =SUBSTITUTE(A1,CHAR(10), ” “)

  • David Cutler

    Member
    July 6, 2022 at 3:45 pm
    Points: 9,678
    Rank: UC2 Brainery Purple Belt IIII UC2 Brainery Purple Belt IIII

    I’ve had good luck saving PDFs as Word documents and then copying the text I need from there. I can’t say that I’ve ever tried it with a drawing though…

  • Vince

    Member
    July 6, 2022 at 3:58 pm
    Points: 4,907
    Rank: UC2 Brainery Orange Belt IIII UC2 Brainery Orange Belt IIII

    There is also supposed to be another method in Excel using the ‘Find and Replace’ function.

    Apparently in the find box you press ctrl + j the. In the replace box you put a space.

    I’ve managed to get this to work a couple of times but most of the time I get an error message.

    I’m not sure if there is a similar function in Word?

  • Troy DeGroot

    Organizer
    July 7, 2022 at 2:02 pm
    Points: 11,697
    Rank: UC2 Brainery Blue Belt I UC2 Brainery Blue Belt I

    @matt-hackman Have you tried the export to Excel or Word functions under the File menu? You can draw a region around a drawing schedule and export it directly to Excel. Maybe this would help?…