Problem with format of exported hours being in quotation marks

[Dana]

I am exporting a tab-delimited text file. (using Save As)
In the output file created by MS Project, the Work field (in hours) is
sometimes in quotation marks. It seems that when the number of hours in the
Work field exceeds 999, it gets quoted as in "1,000 hrs" while 208.10 hrs is
not in quotes.
I think it's because of the comma. All values with a comma separating the
thousands digit are in quotes. For that matter, even the Name field is in
quotes when the Name field contains a comma. the quotes around the Name field
is not a problem for me but I can't have the Work field in quotes.

Is there any way to tell MS Project not to put exported numbers in quotes?

In the Map that I use to do the export, the field formats all default to -
Text.
This is to be expected since the export is to a tab-delilmited txt fille.
So I can't tell the export tool to format the Work field any differently.

 

[John]

I am exporting a tab-delimited text file. (using Save As)
In the output file created by MS Project, the Work field (in hours) is
sometimes in quotation marks. It seems that when the number of hours in the
Work field exceeds 999, it gets quoted as in "1,000 hrs" while 208.10 hrs is
not in quotes.
I think it's because of the comma. All values with a comma separating the
thousands digit are in quotes. For that matter, even the Name field is in
quotes when the Name field contains a comma. the quotes around the Name field
is not a problem for me but I can't have the Work field in quotes.

Is there any way to tell MS Project not to put exported numbers in quotes?

In the Map that I use to do the export, the field formats all default to -
Text.
This is to be expected since the export is to a tab-delilmited txt fille.
So I can't tell the export tool to format the Work field any differently.

Dana,
As far as I know, there is no way to "tell" the export wizard to delete
the thousands marker comma. However, by customizing a spare field to
reformat the Work field, you can then export that field and it won't
have those pesky quotes. Of course it won't have the thousands separator
comma or the "hrs" label either, but I assume those are probably
somewhat pesky also.

Try the following formula in a spare text field (e.g. Text1)
Text1=[Work]/60

Remember to chose the option to use the formula for summary lines.

Hope this helps.
John
Project MVP