Thanks for the feedback. Yes I have been using regex101.com to learn. Throwing more light to this. This is a multiple lines of strings of data.The only static field is the 57A,32A but the others are dynamic and changes with data For use case 2 and 3 Only 32A is static field but the "NKN" and the digits before and after it changes with each data 32A:200117NKN200000000,00 for use case 1 below, only 57A is constant, "FMDKNTLA" is dynamic and can be "ASTGNMLA" with next data :57A:3232324646 FMDKNTLA So I want have it extracted as use case 1 - field and field value : >>>57A - FMDKNTLA but can be "57A - ASTGNMLA" next time use case 2 - field and field value: >>> 32A - NKN but can be "32A - USD" next time use case 3 - field and field value: >>> 32A - 200000000,00 but can be "32A - 3400000" next time Dont know if this helps
... View more