How can I use Search/replace block to take out space betweeen the rows? I have to take _ and - but when i take it leaves the space.. is there a way to take the space out?
I need to do this coz my data for merge from another source require me to concatenate the text, would a space make a difference that would defeat the match/merge?
If so, how to take them out and if not then I can keep going, please suggest. Your video only suggest the simple logic and doesn't mention about removing spaces...
I found the solution for everybody as well.. use Search/Replace block and in the selection criteria press "space bar" and in the Replace with space keep it empty and it will remove all the spaces between the letters :)