Hello Everyone,
I have a collection with columns names as Fund ID, Fund Name, Date and Fund Full Name.
The values in them are (for example) 1811, FTSEDev ETF, 11/6/2018, VAG Canadian Long-term bond.
1904, Canad corp, 11/7/2018, VAG Canadian FTSE development.
1765, U.S TotMKl, 11/2/2018, VAG S&P 500 Index.
I want to get rid of that "VAG" in the Fund Full Name Column. I tried using Replace([Data.Fund Full Name], "VAG", "") in the loop of collection but it is removing VAG for the first row and not to all rows. please help me.
I have a collection with columns names as Fund ID, Fund Name, Date and Fund Full Name.
The values in them are (for example) 1811, FTSEDev ETF, 11/6/2018, VAG Canadian Long-term bond.
1904, Canad corp, 11/7/2018, VAG Canadian FTSE development.
1765, U.S TotMKl, 11/2/2018, VAG S&P 500 Index.
I want to get rid of that "VAG" in the Fund Full Name Column. I tried using Replace([Data.Fund Full Name], "VAG", "") in the loop of collection but it is removing VAG for the first row and not to all rows. please help me.