Hello,
Noticed a lot of Google Docs expertise on this website and in this forum, so here it goes....
I have a column D as a result from =ImportFeed(A1, "Items", False, 50)
which contains text.
Some text in the cell's in D is surrounded by "quotes". I don't want
those quotes, and I want them filtered / stripped / replaced / ...
Isn't this possible?
I am considering Substitute SUBSTITUTE(text, search_text, new text,
occurrence)
Substitutes new text for old text in a string. Text is the text in
which text segments are to be exchanged. Search_text is the text
segment that is to be replaced (a number of times). New text is the
text that is to replace the text segment. Occurrence (optional)
indicates how many occurrences of the search text are to be replaced.
If this parameter is missing, the search text is replaced throughout.
I don't know if I can operate that on my imported output in D, but
nonetheless, First problem is that I cannot escape the character??
So I cannot do a search on the quotes in D with:
substitute(*, ") or substitute(*,\") or ???
Grumbl - who can help?
Thanx!
Devvie Nuis
Conare nullius momenti videri fortasse missilibus careant
------
All spelling mistakes are my own and may only be distributed under the
GNU General Public License! – (© 1995-2001 by Coredump; 2002-9 by
DevNullius)
