Hi Guys,
How can I split the string using Regex Tool.
This is my sample data:
| INVESTMENT HOLDINGS |
| Equity |
| Sample Asia Pacific Income and Growth Fund 18,598.12 17,508.68 4.82% |
| Sample Investment Asia-Pacific Ex-Japan Fund 85,039.16 77,517.74 21.36% |
| Sample Investment Progress Fund 15,741.42 11,796.75 3.25% |
| Sample Investment Regular Savings Fund 89,924.28 66,125.98 18.22% |
| Fixed Income |
| Sample Bond Plus Fund 32,480.68 34,222.10 9.43% |
| Mixed Asset |
| Sample Flexi Growth & Income Fund 142,216.38 108,590.49 29.92% |
| TOTAL INVESTMENT HOLDINGS 384,000.04 315,761.74 86.99% |
| CASH AND DEPOSITS |
| Cash at Bank 47,225.57 13.01% |
| Fixed Deposit (Include Money Market, Repo & Call Deposit) - 0.00% |
This is my desired output:
| Column 1 | Column 2 | Column 3 | Column 4 |
| INVESTMENT HOLDINGS | | | |
| Equity | | | |
| Sample Investment Asia-Pacific Ex-Japan Fund | 18,598.12 | 17,508.68 | 4.82% |
| Sample Investment Asia-Pacific Ex-Japan Fund | 85,039.16 | 77,517.74 | 21.36% |
| Sample Investment Progress Fund | 15,741.40 | 11,796.75 | 3.25% |
| Sample Investment Regular Savings Fund | 89,924.28 | 66,125.98 | 18.22% |
| Fixed Income | | | |
| Sample Bond Plus Fund | 32,480.68 | 34,222.10 | 9.43% |
| Mixed Asset | | | |
| Sample Flexi Growth & Income Fund | 142,216.38 | 108,590.49 | 29.92% |
| TOTAL INVESTMENT HOLDINGS | 384,000.04 | 315,761.74 | 86.99% |
| CASH AND DEPOSITS | | | |
| Cash at Bank | 47,225.57 | 13.01% | |
| Fixed Deposit (Include Money Market, Repo & Call Deposit) | | - | 0.00% |
Thank you!
