We recommend switching to the latest versions of Edge, Firefox, Chrome or Safari. Using Internet Explorer will result in a loss of website functionality.

Text to Column

Comments

2 comments

  • Avatar
    Catharine Coleman

    Hi Khai,

    Yes, there is a node that can do this quickly.  It is called the"Delimited File" node.

    I created a file that contained one line that looked like this:

    Col 1&Col 2&Col 3&Col 4

    I ended the line with a carriage return.

    I dragged the Delimited file node to the canvas and filled in the following properties under Input:

    • File - I specified the file I created above
    • FieldDelimiter - &
    • RecordDelimiter - \n

    I then ran the node.  It produce 4 columns named Col 1, Col 2, Col 3, Col 4

    Let me know if that works.

    0
    Comment actions Permalink
  • Avatar
    Catharine Coleman

    Hi,

    If your data is already present on an output pin, then you could try processing it with a filter node.  In the filter, use this code:

    t=myField.split("&")

    emit t[0] as col1
    emit t[1] as col2
    emit t[2] as col3

     

    0
    Comment actions Permalink

Please sign in to leave a comment.