Set custom field with part of another field

[Yuliya Kazakova]

Trying to find a way to resolve my problem.

I have standard field Description with some text. In this text I have some Id value (ID 12345 - value is different for every issue). Is there a way to take this value Id from Description and set it into another custom field?

I'm bad with scripts, but seems like it can be managed only by using script runner?

[Yogesh Mude]

HI @Yuliya Kazakova,

You can Use CSV Import.

The steps is as follows...

1. Create a new Custom field let say Another Custom Field.
2. Run the JQL and select the issue that contains the Description field like Project = XXX and issue type = ABC and add the Description field in Columns
3. Export an Excel/CSV with Issue Key and the value of Standard field (Description ).
4. Open the excel and edit.
5. Remove the unwanted first lines that means it should contain only Headers and data.
6. Add the one more column Summary without data into the excel.
7. Save the CSV file.
8. Import the CSV file using External System import and do the mapping like

            Summary to Summary.

             Issue Key to Issue Key.

             Old Standard field (Description) to New custom Field (Created in Step 1).

Please try this first on Test/UAT Instance and confirm, it looks fine then only try on production. 

[Yuliya Kazakova]

Thank you. It makes sense for existed issues, but what if I want to do the it in every new issue? 

I thought about it like that:

New issue (which contains Id value) is created;

I change workflow status;

"Post functions" of transition run the script.

But maybe there are another way to do it (using scripted field or something)?