[Hidden-tech] Text Manipulation Problem

[Edward Bride]

In my (admittedly limited) experience with this approach in converting, the hard carriage returns don’t make the conversion into Word; even if the line return works, the instruction doesn’t show as a searchable term (the ^p) so they don’t show up in a search-and-replace. What have others’ experiences been, with this approach? I’d certainly like a work-around, as well.

 

Be careful about globally changing spaces into commas, so an address like 356 East Main St. doesn’t show up as 350 East,Main,St. and North Adams doesn’t show up as North,Adams.

Ed

 

 

From: hidden-discuss-bounces at lists.hidden-tech.net [mailto:hidden-discuss-bounces at lists.hidden-tech.net] On Behalf Of Shel Horowitz
Sent: Saturday, October 21, 2017 10:04 PM
To: David Greenberg <david.greenberg3 at gmail.com>
Cc: Hidden-Tech Tech <hidden-discuss at lists.hidden-tech.net>
Subject: Re: [Hidden-tech] Text Manipulation Problem

 

If you want something less techie than Perl, try this, using Word's ability to search-replace non-alphanumeric characters:

 

1.	Pop the text into Word. Save the file under another name in case you mess up.
2.	Using search-and-replace, change all instances of 01301 to 01301&^&^ (or any other string that would not show up in the data file)
3.	change all (413)<space> to (413)<no space>
4.	Change all remaining spaces to commas
5.	Change all paragraph returns to commas put ^p into the Find box and make sure the p is lower-case)
6.	Change all &^&^ back to ^p
7.	Scan the file for any tweaks you need, like changing ,, to just one ,
8.	Save as text

Whole thing should take about three minutes.




 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.hidden-tech.net/pipermail/hidden-discuss/attachments/20171022/26db66d7/attachment-0001.html