Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pipe Character - Any problems using in excel or uses in excel?
I am going to be receiving csv files that contain the "pipe" characters ||
but are not to be used as delimiting characters. I am not aware of any use of | in Excel and have tried to see if I can create any problems or unexpected results by using it, and so far I have not. Does anyone know if this could create problems? My eventual plan is to manipulate this file via macro or VB and then send parts of it out via email automatically. Thanks! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pipe Character - Any problems using in excel or uses in excel?
The pipe character is used in DD remote reference formulae, like this
=STOCK|NYSE!WHITCO don't know if this will cause you any problems, but AFAIK thats the only place its used. Charles ______________________ Decision Models FastExcel 2.3 now available Name Manager 4.0 now available www.DecisionModels.com "BenS" wrote in message ... I am going to be receiving csv files that contain the "pipe" characters || but are not to be used as delimiting characters. I am not aware of any use of | in Excel and have tried to see if I can create any problems or unexpected results by using it, and so far I have not. Does anyone know if this could create problems? My eventual plan is to manipulate this file via macro or VB and then send parts of it out via automatically. Thanks! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pipe Character - Any problems using in excel or uses in excel?
Don't try to use the pipe character in a name such as a file name. It's
illegal (as are \, ?, :, *, ", <. - just like DOS). As data, the pipe character is fine. "BenS" wrote in message ... I am going to be receiving csv files that contain the "pipe" characters || but are not to be used as delimiting characters. I am not aware of any use of | in Excel and have tried to see if I can create any problems or unexpected results by using it, and so far I have not. Does anyone know if this could create problems? My eventual plan is to manipulate this file via macro or VB and then send parts of it out via automatically. Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Export as pipe separated | Excel Discussion (Misc queries) | |||
Excel-Match 1st text character in a string to a known character? | Excel Worksheet Functions | |||
Save excel file with pipe separated | Excel Discussion (Misc queries) | |||
Where to find Excel sheet with Pipe & Forging charts and sizes. | Excel Worksheet Functions | |||
How can I save Excel am spreadsheet as pipe delimiter? | Excel Discussion (Misc queries) |