Extracting notepad to excel

[smarthari1997 (Hp)]

Hi All,
I need to extract these data to excel in a single row. And the values are as Map (key value)pair. All the key should be in one row as header and the value should be in another row as values.Can anyone help me in this case

[Rahul_Unnikrishnan]

Hello @smarthari1997

Here there are some values which are repeating… for eg HOMEDEPOSIT,amt etc… so those duplicates need to remove?

Please add this to excel and share the screenshot of expected output

[smarthari1997 (Hp)]

Like these i need to print in excel up to Amt :0.00
.

[postwick (Paul)]

Read the text file into a variable and then use RegEx to get the individual values you need. Lots of posts here on how to do that with RegEx.