LAE

Welcome to the LAE community!  Please feel free to start a discussion in the discussion tab or join in a conversation.

Discussions

Members

Resources

Events

 View Only
  • 1.  Separating Text in a column

    Employee
    Posted 01-12-2018 09:24

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: james.bruty

    Hi,

    I have comma delimited file where some of the text is in multiple lines within the same row (a line break within a column (ALT+Enter in Excel)). I need to pick out specific text from this column and am wondering if anyone's done this before? I would really like to get all text from this column onto one line if this is possible?

    Any assistance would be appreciated!

    Thanks

    James


  • 2.  RE: Separating Text in a column

    Employee
    Posted 01-15-2018 04:30

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: awilliams1024

    Hi James,

    You can use the following script in a Filter node:

    single_line = Data.replace("\n", " ")
    emit *,single_line


    Assuming 'Data' is the input field containing the multi-line data.

    Regards,
    Adrian


  • 3.  RE: Separating Text in a column

    Employee
    Posted 02-06-2018 07:42

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: BookerMUt

    Hi

    I want to include a column with the in-degree for each node to my Data Laboratory. Is there a simple way for doing this?

    Thanks.


  • 4.  RE: Separating Text in a column

    Employee
    Posted 02-06-2018 09:20

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: awilliams1024

    Can you clarify what you are trying to do?