Hi All,
I am trying to find occurrence of a keyword ,capturing the content of a string after and before that keyword.
I need to take -1 and +1 position of the keyword ,transpose the -1 position and keep the +1 as its value.
For eg i have a string "Goods at store tshirt,jeans,jackets tshirt quantity:100,jeans quantity:50,jacket quantity:100"
Now i want tshirt,jackets and jeans going as column header and quantities to be stored in respective columns.
But these goods can be dynamic ,sometime we have jacket and even socks can step in. Or sometimes jacket wont be there at all. So we need to handle dynamic scenario as well.Also please note all the above operations would have to be performed on a file.
