I have to locate & remove carriage returns in a HUGE Excel file and can't find a way. There doesn't seem to be a 'View Hidden Characters' option, which might at least let me do a search & replace. The removal is for a specific column of data, which looks like this.
Paste Tab and Return characters into text fields | 8 comments | Create New Account
Click here to return to the 'Paste Tab and Return characters into text fields' hint |
The following comments are owned by whoever posted them. This site is not responsible for what they say.
Try it with alt+Tab or alt+Return. It works in many cases (so f.e. in TextEdit).
Right, works most of the time with the option (ALT) key.
---
this is not the sig you`re looking for.
---
this is not the sig you`re looking for.
cheers, i've been copying the tab and return very often, thanks for nice hint!
![Cut Adding And Carriage Return Characters For Mac Cut Adding And Carriage Return Characters For Mac](/uploads/1/2/5/8/125846011/748217759.jpg)
Still a good tip to know if you use Witch [which I do], which uses alt-Tab to switch among windows. Thanks!
In addition to Option+Return or +Tab, you can try Ctrl-Q followed by Return or Tab. You can also try a bunch of other keys, such as Backspace or Esc.
Such a combination has been used in the Unix-world, which is probably why you can find it in OS X.
As for uses... I've used a line feed occasionally in ichat. Tab is good when telling someone about a problem in source code, for example.
Backspace is quite nifty. You can for example type 'th<backspace>ree', which when pasted into Terminal yields 'tree'.
Such a combination has been used in the Unix-world, which is probably why you can find it in OS X.
As for uses... I've used a line feed occasionally in ichat. Tab is good when telling someone about a problem in source code, for example.
Backspace is quite nifty. You can for example type 'th<backspace>ree', which when pasted into Terminal yields 'tree'.
This is a technique I've been using a lot as a poor man's regexp.
For example let's say you have a list of words separated by spaces, and you want to make it separated by line breaks. Well, that's easy enough, just find and replace all for the space character to a line break.
OK, well what if you have that same text, but now you realize you want a star in front of every line of text? Simple, select from the end of one line to the beginning of another, copy that and put it into the find and replace fields, then at the end of the replace field, add a star. Go back and add a star to the first line and you're all set.
Other useful functions: changing a bunch of text so that there are two line breaks between paragraphs instead of one, making sure there's only one space between words instead of two, reformatting an HTML list to match some template you've made (I often change iPhoto's output page to use CSS instead of tables)…
For example let's say you have a list of words separated by spaces, and you want to make it separated by line breaks. Well, that's easy enough, just find and replace all for the space character to a line break.
OK, well what if you have that same text, but now you realize you want a star in front of every line of text? Simple, select from the end of one line to the beginning of another, copy that and put it into the find and replace fields, then at the end of the replace field, add a star. Go back and add a star to the first line and you're all set.
Other useful functions: changing a bunch of text so that there are two line breaks between paragraphs instead of one, making sure there's only one space between words instead of two, reformatting an HTML list to match some template you've made (I often change iPhoto's output page to use CSS instead of tables)…
if you use Ms Word, a tab = ^t and return = ^p
if you use BBEdit, a tab = t and return = p
very useful in 'search & replace'
if you use BBEdit, a tab = t and return = p
very useful in 'search & replace'
In the OS9 days, pasting a carriage return or two into the beginning of a file name was a great invisible way to make the file rank higher alphabetically in a folder. My initial searches for hints have not revealed a way to do this in OS X. I would be happy to be corrected.