I have to compare 2 files by using comm command like the below
comm -23 csv1 csv2 > csv3
I seem to face the problem that both the csv are generated from different sources (csv1 is extracted from another csv containing many columns and first column is extracted from it and csv 2 is generated from DB and consists of some extra spaces)
csv2 contains data like below
Vp1234▒▒▒▒ vp4567▒▒▒▒ vp6789-v2▒▒▒
▒ indicates a space). While csv1 contains similar data (which is why I have to compare to find the data only existing in csv1) but without spaces.
Hence its difficult to compare both.
I have tried sed but it didn't work or tried wrongly.