Forum Discussion

arvindnsn's avatar
arvindnsn
Contributor
2 years ago
Solved

Decode column name that has @ as a prefix

Hello,  I have source data in XML format and all the column entities have "@" as a prefix. I am trying the following expression using "hasPath" function in a mapper to determine if the output of the...
  • svatada's avatar
    svatada
    2 years ago

    arvindnsn Try enclosing the fields within [ ].

    ex: $['@ID']

    $.hasOwnProperty('[\'@ID\']')

     

svatada's avatar
svatada
Former Employee
2 years ago

arvindnsn Try enclosing the fields within [ ].

ex: $['@ID']

$.hasOwnProperty('[\'@ID\']')

 

  • arvindnsn's avatar
    arvindnsn
    Contributor
    2 years ago

    svatada. Thanks for the solution. yes it works with the escape character mentioned in the expression.

    works for both $.hasOwnProperty('[\'@ID\']') and $.hasPath('[\'@ID\']').