Finding and replacing text formatting for strings within a cell
 

I have four high-priority projects to finish in the next four days and
I think I'm too stressed out to find an answer for this sub-problem in
Excel.

I need to export a worksheet that has text formatting withen cells to
CSV. The program that reads in the CSV needs to restore the text
formatting. Here is an example with BOLDing:

1. Find a cell that has characters in BOLD. This may be the first
character in the cell, or a string of characters anywhere in the cell.
2. Save the contents of the cell.
2. Determine the beginning and ending characters of strings in the
cell that have a text format of BOLD.
3. Pre-pend and append <BOLD and </BOLD to the string. NOTE: this is
not HTML, I just chose them as a meaningful term.
4. Put everything back into the cell. I don't care if the whole cell
is now bold or not as I'm going to export to a CSV.

The programming importing the data can't read RTF files. And I can't
find a way to get the data into RTF anyway.

I tried using XML output from Excel using an XML Map in the hopes that
I could find a way to keep the formatting using XML tags, but I can't
find a way to keep the formatting. Probably my inexperience in
Schemas, but I don't have time to gain experience before this is all
due.

Help? Please? Anyone?

D

Finding and replacing text formatting for strings within a cell
 

Do you work with Jeff?

http://groups.google.co.uk/group/mic...231f7f02595d54

or

http://snipurl.com/1lrqo

Try the 7th message in the thread.

WhyNot? wrote:

I have four high-priority projects to finish in the next four days and
I think I'm too stressed out to find an answer for this sub-problem in
Excel.

I need to export a worksheet that has text formatting withen cells to
CSV. The program that reads in the CSV needs to restore the text
formatting. Here is an example with BOLDing:

1. Find a cell that has characters in BOLD. This may be the first
character in the cell, or a string of characters anywhere in the cell.
2. Save the contents of the cell.
2. Determine the beginning and ending characters of strings in the
cell that have a text format of BOLD.
3. Pre-pend and append <BOLD and </BOLD to the string. NOTE: this is
not HTML, I just chose them as a meaningful term.
4. Put everything back into the cell. I don't care if the whole cell
is now bold or not as I'm going to export to a CSV.

The programming importing the data can't read RTF files. And I can't
find a way to get the data into RTF anyway.

I tried using XML output from Excel using an XML Map in the hopes that
I could find a way to keep the formatting using XML tags, but I can't
find a way to keep the formatting. Probably my inexperience in
Schemas, but I don't have time to gain experience before this is all
due.

Help? Please? Anyone?

D

--

Dave Peterson

Finding and replacing text formatting for strings within a cell
 

I work with a Jeff, but not this one.

Thanks for the reference, I really appreciate it. Between the
projects, my wife's cancer, my bipolar son, the house remodeling, and
unnecessary paperwork I think I'm starting to crack under the strain,
slip, slide, perish. You're very kind to help.

D


On Wed, 23 May 2007 17:59:02 -0500, Dave Peterson
wrote:

Do you work with Jeff?

http://groups.google.co.uk/group/mic...231f7f02595d54

or

http://snipurl.com/1lrqo

Try the 7th message in the thread.

WhyNot? wrote:

I have four high-priority projects to finish in the next four days and
I think I'm too stressed out to find an answer for this sub-problem in
Excel.

I need to export a worksheet that has text formatting withen cells to
CSV. The program that reads in the CSV needs to restore the text
formatting. Here is an example with BOLDing:

1. Find a cell that has characters in BOLD. This may be the first
character in the cell, or a string of characters anywhere in the cell.
2. Save the contents of the cell.
2. Determine the beginning and ending characters of strings in the
cell that have a text format of BOLD.
3. Pre-pend and append <BOLD and </BOLD to the string. NOTE: this is
not HTML, I just chose them as a meaningful term.
4. Put everything back into the cell. I don't care if the whole cell
is now bold or not as I'm going to export to a CSV.

The programming importing the data can't read RTF files. And I can't
find a way to get the data into RTF anyway.

I tried using XML output from Excel using an XML Map in the hopes that
I could find a way to keep the formatting using XML tags, but I can't
find a way to keep the formatting. Probably my inexperience in
Schemas, but I don't have time to gain experience before this is all
due.

Help? Please? Anyone?

D

Finding and replacing text formatting for strings within a cell
 

Good luck with everything. I hope things turn around for your family.

WhyNot? wrote:

I work with a Jeff, but not this one.

Thanks for the reference, I really appreciate it. Between the
projects, my wife's cancer, my bipolar son, the house remodeling, and
unnecessary paperwork I think I'm starting to crack under the strain,
slip, slide, perish. You're very kind to help.

D

On Wed, 23 May 2007 17:59:02 -0500, Dave Peterson
wrote:

Do you work with Jeff?

http://groups.google.co.uk/group/mic...231f7f02595d54

or

http://snipurl.com/1lrqo

Try the 7th message in the thread.

WhyNot? wrote:

I have four high-priority projects to finish in the next four days and
I think I'm too stressed out to find an answer for this sub-problem in
Excel.

I need to export a worksheet that has text formatting withen cells to
CSV. The program that reads in the CSV needs to restore the text
formatting. Here is an example with BOLDing:

1. Find a cell that has characters in BOLD. This may be the first
character in the cell, or a string of characters anywhere in the cell.
2. Save the contents of the cell.
2. Determine the beginning and ending characters of strings in the
cell that have a text format of BOLD.
3. Pre-pend and append <BOLD and </BOLD to the string. NOTE: this is
not HTML, I just chose them as a meaningful term.
4. Put everything back into the cell. I don't care if the whole cell
is now bold or not as I'm going to export to a CSV.

The programming importing the data can't read RTF files. And I can't
find a way to get the data into RTF anyway.

I tried using XML output from Excel using an XML Map in the hopes that
I could find a way to keep the formatting using XML tags, but I can't
find a way to keep the formatting. Probably my inexperience in
Schemas, but I don't have time to gain experience before this is all
due.

Help? Please? Anyone?

D

--

Dave Peterson