Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.tables
|
|||
|
|||
Word delimiters?
My client database was corrupted when an illegal operation occured on my
machine. This was in table format though after corruption the table was removed and the columns have been separated with a character (ie square) that is unrecognisable in WORD! I have searched the discussion forums and cannot locate a similar issue. Could anyone shed any light in coverting this back into table format please. Thank you. |
#2
Posted to microsoft.public.word.tables
|
|||
|
|||
Word delimiters?
Even though the character displays as a square, you may be able to
replace it with a valid delimiter. Select one of these squares and copy it to the clipboard. Open the Replace dialog. Paste the character from the clipboard (using Ctrl+V) into the Find What box. If you want the delimiter to be a comma, type a comma in the Replace With box; if you want it to be a tab, type the code ^t in the Replace With box. Click the Replace All button and see what happens. If that doesn't do the whole job, come back and tell us what happened. -- Regards, Jay Freedman Microsoft Word MVP FAQ: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. On Mon, 5 Mar 2007 14:49:25 -0800, Nicole Beath Nicole wrote: My client database was corrupted when an illegal operation occured on my machine. This was in table format though after corruption the table was removed and the columns have been separated with a character (ie square) that is unrecognisable in WORD! I have searched the discussion forums and cannot locate a similar issue. Could anyone shed any light in coverting this back into table format please. Thank you. |
#3
Posted to microsoft.public.word.tables
|
|||
|
|||
Word delimiters?
Thanks for the reply Jay! I have tried your method thought the character is
not being recognised by WORD when i try to paste it (i tried ctrl v and also via the icon - no success) in 'Find/Replace'. I dont think the square (or upside down rectangle) is in fact a character as I would be able to cut/paste (even a symbol) into other applications. I can cut and paste (using quick keys/icons) into the same document though that is it. I have cut/pasted a segment of the doc (see below - eg1) - as you can see the sq/rect is not showing and there is no break in the text: (eg1): 981005Grosper Pty Limited (Marty Perry)Application for Off-Licence (Wholesale):- Beverly Hills Cellars, 497 King Georges Rd, Beverly Hills17.07.9719.12.970071 (Box 4) Where I require the tabs is as follows (see below eg2 @ *) (eg2): 981005**Grosper Pty Limited (Marty Perry)*Application for Off-Licence (Wholesale):- Beverly Hills Cellars, 497 King Georges Rd, Beverly Hills*17.07.97*19.12.97*0071 (Box 4)** This document is driving me crazy.... i've exhausted all avenues in the help system - please save me Jay!! "Jay Freedman" wrote: Even though the character displays as a square, you may be able to replace it with a valid delimiter. Select one of these squares and copy it to the clipboard. Open the Replace dialog. Paste the character from the clipboard (using Ctrl+V) into the Find What box. If you want the delimiter to be a comma, type a comma in the Replace With box; if you want it to be a tab, type the code ^t in the Replace With box. Click the Replace All button and see what happens. If that doesn't do the whole job, come back and tell us what happened. -- Regards, Jay Freedman Microsoft Word MVP FAQ: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. On Mon, 5 Mar 2007 14:49:25 -0800, Nicole Beath Nicole wrote: My client database was corrupted when an illegal operation occured on my machine. This was in table format though after corruption the table was removed and the columns have been separated with a character (ie square) that is unrecognisable in WORD! I have searched the discussion forums and cannot locate a similar issue. Could anyone shed any light in coverting this back into table format please. Thank you. |
#4
Posted to microsoft.public.word.tables
|
|||
|
|||
Word delimiters?
Hi Nicole,
Try copying the character by selecting it then pressing Ctrl-C. Then paste into the 'Find' box. If that doesn't work, try copying a single whole string into Excel, then deleting all except one problem character. Then, in an adjoining cell, enter =CODE(A1), where A1 is the cell you pasted the text into. What value does Excel return? Back in Word, open the 'Find' box and hold down the Alt key while inputting the number Excel gave you as a 3-digit value (add leading 0s if needed). Cheers -- macropod [MVP - Microsoft Word] ------------------------- "Nicole Beath" wrote in message ... Thanks for the reply Jay! I have tried your method thought the character is not being recognised by WORD when i try to paste it (i tried ctrl v and also via the icon - no success) in 'Find/Replace'. I dont think the square (or upside down rectangle) is in fact a character as I would be able to cut/paste (even a symbol) into other applications. I can cut and paste (using quick keys/icons) into the same document though that is it. I have cut/pasted a segment of the doc (see below - eg1) - as you can see the sq/rect is not showing and there is no break in the text: (eg1): 981005Grosper Pty Limited (Marty Perry)Application for Off-Licence (Wholesale):- Beverly Hills Cellars, 497 King Georges Rd, Beverly Hills17.07.9719.12.970071 (Box 4) Where I require the tabs is as follows (see below eg2 @ *) (eg2): 981005**Grosper Pty Limited (Marty Perry)*Application for Off-Licence (Wholesale):- Beverly Hills Cellars, 497 King Georges Rd, Beverly Hills*17.07.97*19.12.97*0071 (Box 4)** This document is driving me crazy.... i've exhausted all avenues in the help system - please save me Jay!! "Jay Freedman" wrote: Even though the character displays as a square, you may be able to replace it with a valid delimiter. Select one of these squares and copy it to the clipboard. Open the Replace dialog. Paste the character from the clipboard (using Ctrl+V) into the Find What box. If you want the delimiter to be a comma, type a comma in the Replace With box; if you want it to be a tab, type the code ^t in the Replace With box. Click the Replace All button and see what happens. If that doesn't do the whole job, come back and tell us what happened. -- Regards, Jay Freedman Microsoft Word MVP FAQ: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. On Mon, 5 Mar 2007 14:49:25 -0800, Nicole Beath Nicole wrote: My client database was corrupted when an illegal operation occured on my machine. This was in table format though after corruption the table was removed and the columns have been separated with a character (ie square) that is unrecognisable in WORD! I have searched the discussion forums and cannot locate a similar issue. Could anyone shed any light in coverting this back into table format please. Thank you. |
#5
Posted to microsoft.public.word.tables
|
|||
|
|||
Word delimiters?
Or try ^7 for the square, which is the control character Word usually uses
for end-of-cell and end-of-row markers. Good luck, Klaus "macropod" schrieb im Newsbeitrag ... Hi Nicole, Try copying the character by selecting it then pressing Ctrl-C. Then paste into the 'Find' box. If that doesn't work, try copying a single whole string into Excel, then deleting all except one problem character. Then, in an adjoining cell, enter =CODE(A1), where A1 is the cell you pasted the text into. What value does Excel return? Back in Word, open the 'Find' box and hold down the Alt key while inputting the number Excel gave you as a 3-digit value (add leading 0s if needed). Cheers -- macropod [MVP - Microsoft Word] ------------------------- "Nicole Beath" wrote in message ... Thanks for the reply Jay! I have tried your method thought the character is not being recognised by WORD when i try to paste it (i tried ctrl v and also via the icon - no success) in 'Find/Replace'. I dont think the square (or upside down rectangle) is in fact a character as I would be able to cut/paste (even a symbol) into other applications. I can cut and paste (using quick keys/icons) into the same document though that is it. I have cut/pasted a segment of the doc (see below - eg1) - as you can see the sq/rect is not showing and there is no break in the text: (eg1): 981005Grosper Pty Limited (Marty Perry)Application for Off-Licence (Wholesale):- Beverly Hills Cellars, 497 King Georges Rd, Beverly Hills17.07.9719.12.970071 (Box 4) Where I require the tabs is as follows (see below eg2 @ *) (eg2): 981005**Grosper Pty Limited (Marty Perry)*Application for Off-Licence (Wholesale):- Beverly Hills Cellars, 497 King Georges Rd, Beverly Hills*17.07.97*19.12.97*0071 (Box 4)** This document is driving me crazy.... i've exhausted all avenues in the help system - please save me Jay!! "Jay Freedman" wrote: Even though the character displays as a square, you may be able to replace it with a valid delimiter. Select one of these squares and copy it to the clipboard. Open the Replace dialog. Paste the character from the clipboard (using Ctrl+V) into the Find What box. If you want the delimiter to be a comma, type a comma in the Replace With box; if you want it to be a tab, type the code ^t in the Replace With box. Click the Replace All button and see what happens. If that doesn't do the whole job, come back and tell us what happened. -- Regards, Jay Freedman Microsoft Word MVP FAQ: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. On Mon, 5 Mar 2007 14:49:25 -0800, Nicole Beath Nicole wrote: My client database was corrupted when an illegal operation occured on my machine. This was in table format though after corruption the table was removed and the columns have been separated with a character (ie square) that is unrecognisable in WORD! I have searched the discussion forums and cannot locate a similar issue. Could anyone shed any light in coverting this back into table format please. Thank you. |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Default delimiters saved in word | Mailmerge | |||
How do I set up delimiters in my Word data file? | Mailmerge | |||
italics replacement with delimiters | Microsoft Word Help | |||
Header Record Delimiters fails . . . | Mailmerge | |||
Disappeearing Delimiters | Mailmerge |