Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
General
GeneralPortable MacsHardwareNetworking
Applications
Mac ApplicationsEudoraFirefox / MozillaInternet ExplorerOutlook ExpressMS OfficeEntourageExcelPowerPointWordVirtual PCMedia PlayerOther MS Products
Programming
Mac ProgrammingCodeWarriorPerl
Country Specific
Australian Mac GroupUK Mac Group

Mac Forum / General / General / February 2006



Tip: Looking for answers? Try searching our database.

Where is the pipe

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Marshall Dudley - 27 Feb 2006 17:37 GMT
I have a customer that is using a Mac, and has downloaded a database
that is pipe delimited.  She is trying to import it into Excel, but
cannot find the pipe on her keyboard. It is not where it is on the IBM
keyboard, and I can find no keyboard layouts on the Apple site.

Can someone tell me what to tell her.

Thanks,

Marshall
Gregory Weston - 27 Feb 2006 17:52 GMT
> I have a customer that is using a Mac, and has downloaded a database
> that is pipe delimited.  She is trying to import it into Excel, but
> cannot find the pipe on her keyboard. It is not where it is on the IBM
> keyboard, and I can find no keyboard layouts on the Apple site.
>
> Can someone tell me what to tell her.

I think it may have moved, physically, a couple of times over the last
two decades, but assuming a US layout it'll be shift-backslash which, at
least on recent keyboards, is above the return key.

Greg

Signature

"Congurutulation!!!" - The subject line on some spam I received last night.
I have no idea what it means, but it's such a cool "word" (by which I mean
pronouncable sequence of letters) regardless.

Marshall Dudley - 27 Feb 2006 17:57 GMT
> > I have a customer that is using a Mac, and has downloaded a database
> > that is pipe delimited.  She is trying to import it into Excel, but
[quoted text clipped - 6 lines]
> two decades, but assuming a US layout it'll be shift-backslash which, at
> least on recent keyboards, is above the return key.

Darn, that is where it is on my IBM keyboard, and she said it was not there on
hers.

Thanks anyway,

Marshall

> Greg
>
> --
> "Congurutulation!!!" - The subject line on some spam I received last night.
> I have no idea what it means, but it's such a cool "word" (by which I mean
> pronouncable sequence of letters) regardless.
Mike Rosenberg - 27 Feb 2006 18:08 GMT
> > I think it may have moved, physically, a couple of times over the last
> > two decades, but assuming a US layout it'll be shift-backslash which, at
> > least on recent keyboards, is above the return key.
>
> Darn, that is where it is on my IBM keyboard, and she said it was not
> there on hers.

Bear in mind that she could be using a keyboard from many different
manufacturers.  On my Kensington keyboard, for example, it's the key
Greg described but it's to the left of the return key, not above it.

Signature

Mike Rosenberg
<http://www.macconsult.com> Macintosh consulting services for NE Florida
<http://www.cafepress.com/macconsult,macconsult4> Mac-themed T-shirts
<http://bogart-tribute.net> Tribute to Humphrey Bogart

Paul Förster - 27 Feb 2006 22:52 GMT
Hi Marshall,

> I have a customer that is using a Mac, and has downloaded a database
> that is pipe delimited.  She is trying to import it into Excel, but
> cannot find the pipe on her keyboard. It is not where it is on the IBM
> keyboard, and I can find no keyboard layouts on the Apple site.
> Can someone tell me what to tell her.

... on my PowerBook it's on alt-7, backslash is shift-alt-7 and slash
is on shift-7. But that's a) on a PowerBook and b) on a Swiss-German
keyboard layout. ;-)

Switching to US layout moves it to shift-backslash next to the return key.

Hope this helps.
Signature

cul8er

Paul
paul.foerster@gmx.net

Calum Benson - 27 Feb 2006 23:12 GMT
> I have a customer that is using a Mac, and has downloaded a database
> that is pipe delimited.  She is trying to import it into Excel, but
> cannot find the pipe on her keyboard. It is not where it is on the IBM
> keyboard, and I can find no keyboard layouts on the Apple site.
>
> Can someone tell me what to tell her.

There's always one workaround for characters you can't find on your
keyboard: use the Character Palette, which is found on the flag menu on
the menu bar (you may need to enable it in the International/Input Menu
control panel first).

Find the pipe character in the Character Palette window, select it,
focus the text field you need to type the pipe character into, and
finally click "Insert" in the Character Palette window.

If you're going to need to do it again in future, you can even add the
pipe character to the 'favourites' section of the Character Palette.
Philo D - 28 Feb 2006 13:24 GMT
> Find the pipe character in the Character Palette window,

Of course, you have to know which of the many look-alikes it is.
You want "punctuation, vertical line"
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.