SQL request output parse data for multiple rows

  • 29 November 2021
  • 0 replies
  • 5 views

Hi,

 

I am using SQL request control on nintex form and it is returning output in 6 rows and i need to extract 0 and 1 values from each rows and assign this extracted value to existing textbox on form. Please suggest 

 

SQL REQUEST OUTPUT :

Monday~~0~@60000 ~#150000~$0 ~%0 ~&60000 ~*150000;#
Tuesday~~1~@60000 ~#100000~$0 ~%0 ~&60000 ~*150000;#
Wednesday~~0~@60000 ~#150000~$0 ~%0 ~&60000 ~*150000;#
Thursday~~1~@60000 ~#100000~$0 ~%0 ~&60000 ~*150000;#
Friday~~0~@60000 ~#150000~$0 ~%0 ~&60000 ~*150000;#
Saturday~~0~@60000 ~#150000~$0 ~%0 ~&60000 ~*150000;#
 


0 replies

Be the first to reply!

Reply