aji | Ají - Jolokia 's fancy sister

I have two CSV files output.csv and Roster.csv

"output.csv" has these headers

The below code is used to fetch item list from order_details

Output expected multiple items

Below code works fine for 1 ITEM but the 2nd item/multiple items are not fetched using the below regex.

I want it to be dynamic so that it should work for any number of the item found in the matching pattern.

The regex I have made fetches itemlist from opts.taskDetails.order_details.

I want to optimize the regex/any other better regex to get the following data as is shown in the above image. (which can be 1 item list or multiple).

Also apart from fetching the item details I also want to fetch data which is left after fetching items list from opts.taskDetails.order_details below.

I have the following JSON Output:

I have a json file that I grabbed from a website, it contains some escape characters, here's the file:

Let's say that I have this one table which contain the student marks for each assessment (eg: quiz,test and etc).

This is the original table:

I wanted to convert the assessment type to be the column. This is the output that I want:

/!\ The question is basically solved, see my own answer below for more details and a subsidiary question /!\

I'm trying to add two lines based on specific word, but all I could find is adding everything after some pattern: How to select lines between two marker patterns which may occur multiple times with awk/sed

Which is not what I'm looking after.

Consider the following output:

How can I do this? I want to get the build number from the checked out branch and build it with Maven. Later in my java application I want to use the buildNumber variable as a Revision ID so i'll have more specific details on each project build. I am currently using this code for getting the buildNumber and use resource filtering on it in a build.properties file but the ${buildNumber} from the file doesn't get updated with the revision number.

I'm trying to find something with a wild card search in a cell value. If the value in sheet("FC")Range("I2:I" & LastRowC) - match with the Sheets("Instr"),Range("A130:A190"). means sheet Instr match if few characters match with the other range mentioned above then do something code.

eg in sheet Instr above range a cell value is "Ajith" and In sheet FC above mentioned range one of the cell value is "Aji" the code should identify it.

All the below steps are okay for me except the wild card search through the loop range , please go through the code and range (rename the sheets if necessary as below) and provide an update.