Imported from the Apple Support Forums via the Wayback Machine 🔗
Hi,
I have a text file that has commas separating values. I saved it as a csv, but am not getting the results I need with the csv file. I'd like to replace the commas with a space or a tab.
I know how to use find replace, but I do not know how to indicate these non-printing characters. I tried the ascii code   for space, but i simply get that string of characters replacing my commas.
Imported from the Apple Support Forums via the Wayback Machine 🔗
Hello
If you want to replace space by TAB with TextEdit, it's really easy
In a new document, enter a tab
Select all
Copy to clipboard
Back to the doc to edit
cmd + F
type a space in the "find" field
paste the TAB in the "replace" field
Click "Replace All"
That's all folks.
Yvan KOENIG (from FRANCE jeudi 6 mars 2008 18:38:23)
0
Jerrold Green1·
Imported from the Apple Support Forums via the Wayback Machine 🔗
KW,
You didn't say what program you were using for the Find and Replace, but I'd suggest that Pages would be your best bet. Spaces can be typed-in directly, and several other non-printing characters can be inserted from a drop-down menu.
The Insert drop-down seems to be available only in Pages, as opposed to Numbers and TextEdit.
Jerry
0
KOENIG Yvan·
Imported from the Apple Support Forums via the Wayback Machine 🔗
Hello
If you want to replace comma by TAB with TextEdit, it's really easy
In a new document, enter a tab
Select all
Copy to clipboard
Back to the doc to edit
cmd + F
type a comma in the "find" field
paste the TAB in the "replace" field
Click "Replace All"
That's all folks.
But, I really don't understand what is wrong with your CSV file (except if it hasn't the .csv name extension).
Yvan KOENIG (from FRANCE jeudi 6 mars 2008 18:40:33)
0
KW·
Imported from the Apple Support Forums via the Wayback Machine 🔗
Hi
Thanks to you both for your help. I was able to use Pages to do what the first respondent suggested, but to be clear i was trying to use Numbers to do this.
There used to be a way of specifying the ascii code in the replace field. In the case of space, I believe it is  . It didn't work for me, but nevertheless, the suggestions did.
Mucho Gracias.
KW
0
KOENIG Yvan·
Imported from the Apple Support Forums via the Wayback Machine 🔗
KW wrote:
There used to be a way of specifying the ascii code in the replace field. In the case of space, I believe it is  . It didn't work for me, but nevertheless, the suggestions did.
Who told you that?
There is not such a feature in AppleLand.
In the fields Find and Replace
To enter a space, press the space bar
To enter a TAB, you may press alt + tab
Yvan KOENIG (from FRANCE jeudi 6 mars 2008 21:08:23)
0
Jerrold Green1·
Imported from the Apple Support Forums via the Wayback Machine 🔗