ScriptRunner Read Description Field

[Sarathi Chatterjee]

Hi,

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

Any suggestion how we can do this please ? 

Thank you,

Sar.

[Pramodh M]

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

[Sarathi Chatterjee]

Hey.

Thanks for the prompt reply.

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

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

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