I have to provide a CSV file for a telephone system with names and numbers on for a directory. The numbers cannot contain any spaces, and the names must be 20 characters max.
I have a list of names/numbers, but the numbers have spaces and the names are full names. Is there a way to remove characters over the 20 character limit, and remove the blank spaces from the numbers column?
My current CSV file looks like this:
+------------ NAME ------------+--- NUMBER ---+ | johnathan ferguson suppliers | 01234 567899 | | johnathan ferguson suppliers | 01234 567899 |