Forum Discussion

arvindnsn's avatar
arvindnsn
Contributor
2 years ago
Solved

Comma Separated String into Rows

  Hello,    I have a requirement where a text with "," delimiter has to be generated into rows.  For Example a string or text  $src_name = "AMK, ACK, AGK, ABK" should be generated as following ro...
  • SpiroTaleski's avatar
    SpiroTaleski
    2 years ago

    arvindnsn 

    1) First try to split the string by "," - and as an output you will receive array of records: 

                    ("AMK,ACK,AGK,ABK").split(',')

                   output: ["AMK","ACK","AGK","ABK"]

    2) Then split the array, using JSON Splitter Snap. 

    BR,

    Spiro Taleski

SpiroTaleski's avatar
SpiroTaleski
Valued Contributor
2 years ago

arvindnsn 

1) First try to split the string by "," - and as an output you will receive array of records: 

                ("AMK,ACK,AGK,ABK").split(',')

               output: ["AMK","ACK","AGK","ABK"]

2) Then split the array, using JSON Splitter Snap. 

BR,

Spiro Taleski

  • arvindnsn's avatar
    arvindnsn
    Contributor
    2 years ago

    This worked well. Thank you.

    Also, Is it possible if this can be achieved in a single mapper expression without using the splitter.