LinkedIn
Twitter
I have Raw data that contains Hyphen as a value and this Raw data is used in a pipeline where one of the steps is to use wrangler and make some transformation rules , one of those rules that are written in the recipe of the wrangler is to use find-and-replace and by using it the hyphen disappears from the column although the recipe is (find-and-replace columnname s/"/ /g ) the need of it is to find the quote and replace it with space only and don't have anything to do with the hyphen to be removed, Take into consideration that when the hyphen is involved within a word it is not removed (For example : Tut-Ankh-Amoun Street) but when it is found alone it is removed. You will find an attached photo showing what is actually happening, the recipe here is find-and-replace address s/"/ /g and the result is as the following the empty records on the column address contain - or -- and you will see that when the hyphen is included into words it is not removed
