Results 1 to 4 of 4

Thread: Separating Text in a column

Hybrid View

  1. #1

    Default Separating Text in a column

    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. #2
    Lavastorm Employee
    Join Date
    Nov 2012
    Location
    Warrington, UK
    Posts
    221

    Default

    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. #3

    Default Separating Text in a column

    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. #4
    Lavastorm Employee
    Join Date
    Nov 2012
    Location
    Warrington, UK
    Posts
    221

    Default

    Can you clarify what you are trying to do?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •