ScriptRunner Read Description Field

Question

Hi,

we want to parse the contents of a table using script-runner.

Any suggestion how we can do this please ?

Thank you,

Sar.

Sarathi Chatterjee_b7akb0 · Answer

Hey.

Thanks for the prompt reply.

The Data is in the Description field and is like below -

COUNTERPARTYGROUPNAMEENPARENTTRADEDATECOMMISSIONRATERep変更前BpsABC GROUP 12342022/1/610pemji7

The first row is the header we want to extract each column value and create a sub-tasks for each row in the table  -that; the end goal.

So we were hoping to parse the above as text

COUNTERPARTYGROUPNAMEEN|PARENT|TRADEDATE|COMMISSIONRATE|Rep|変更前Bps|ABC GROUP|1234|2022/1/6|10|pemji|7|

Thanks

Pramodh M · Answer

Hi @Sarathi Chatterjee

Once you get the data from here

https://scriptrunner.adaptavist.com/latest/jira/behaviours-api-quickref.html#_getfieldbyname_fieldname

Parsing can be done via Groovy

May I Know the format of your data via screenshot or example?

Thanks,
Pramodh