#1
|
|||
|
|||
Wildcard for selective deleting
Fellow Forum Members,
I have close to 2,000 rows of table data that looks like this: . Power Supply. . .. ............. .. Washer........................ .. Bolt. . . . . . . . . . . . . ... . The need I have is to get rid of all the PERIODS and SPACES located to the RIGHT of the text. However, the PERIODS and SPACES located to the LEFT of the TEXT needs to remain intact (these PERIODS and SPACES are manually typed in and are there for the purpose of showing assembly hierarchy). All the spaces and periods located to the RIGHT were also manually typed in to represent leading dots. Therefore, they are not consistant and incorrectly done. Some rows have spaces in between the periods and some rows do not. Nevertheless, all these manually done leading dots need to be deleted and replaced with leading dots setup through a TAB Style Definition setup. What is the correct Wild Card formula that I could use with the Find & Replace tool that will accomplish the task of just deleting the PERIODS and SPACES located only to the RIGHT of the TEXT? Any help will be greatly appreciated. Thanks. |
#2
|
|||
|
|||
Hi
Try a comination of these commands using Search and Replace: 1. Search for " ^t" - without the quotes of course. 2. Replace with ^t. This will remove all entries of three spaces and a paragaph mark with a paragraph mark. It will only remove the spaces at the end of each paragraph. You will need to do this multiple time using the Alt+A command follow by clicking on OK each time until you see 0 items found. If you are left with anything remaining you can remove one of the spaces in the search criteria until such time as you achieve what you want. It sound complex but it is not. You can replace the spaces in th search criteria with dots or whatever you need to remove. Come back if you have any further problems. Good luck. Tony |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Selective handouts | fozzie | PowerPoint | 2 | 03-03-2012 12:45 PM |
Wildcard Problem with Emailadresses | Fmax | Word | 1 | 06-17-2010 06:09 AM |
Wildcard search help. | Kempston | Word | 0 | 11-13-2009 03:58 AM |
Help with creating selective documents | Pinklady219 | Word | 0 | 07-22-2009 05:49 AM |
Extract from String using Wildcard | whousedmy | Word | 0 | 05-21-2009 01:35 AM |