How to split and store splited data in macro

sgnarkhede2016sgnarkhede2016 Member Posts: 152 Contributor II
edited August 2020 in Help
Hello,
I have one Column "Parameter" that contains  values below
Parameter
Financial Product=REMITTANCE|MESSAGEDIRECTION=I

I want to store both in macro after split
like 
%{Key}   %{value}
%{key_1}  %{value_1}


Tagged:

Answers

  • hbajpaihbajpai Member Posts: 102 Unicorn
    Hey @sgnarkhede2016

    You can split and save them using extract macro. Can you elaborate where you are facing issues?
    Best,
    Harshit
  • sgnarkhede2016sgnarkhede2016 Member Posts: 152 Contributor II
    As mentioned above I have one column that contain values "Financial Product=REMITTANCE|MESSAGEDIRECTION=I"
    I want to spit it first then store in macro dynamically means if in future instead of two key maybe three keys present then how to handle this like "Financial Product=REMITTANCE|MESSAGEDIRECTION=I|CUST_TYPE=NC" after storing i want to filtered it out by passinng macros
Sign In or Register to comment.