I have a text file with about 10000 lines of text. The text file is in JSON format. I want to cut (& keep in clipboard) the data found after the ':' colon symbol.
{
"Cust_Data": {
"First Name": "John",
"Last Name": "Doe",
"Email Address": "[email protected]",
"City": "New York City",
"State": "New York"
}.
"Cust_Account": {
"Account Number": "57235286096572",
"Branch Code": "US0163GR",
"Routing Number": "CHAUSA56325",
"Bank Name": "Bank of America",
"SWIFT Code": "SW356FGH6534567",
"Date of Remittance": "04-30-2005"
}.
.....
.....
.....
This is what I want as the result:
{
"Cust_Data": {
"First Name":
"Last Name":
"Email Address":
"City":
"State":
}.
"Cust_Account": {
"Account Number":
"Branch Code":
"Routing Number":
"Bank Name":
"SWIFT Code":
"Date of Remittance":
}.
........
........
........
The clipboard should contain the data that is removed from the text file.
Please suggest me an idea to achieve this in Notepad ++ using Regex, or any other options.
:[^{\n]*
by: