|
|
Rank: Newbie
Joined: 5/3/2013
Posts: 4
Location: CA
|
Hello Guru's,
I need some help please. I need my xml to output leading zeros. I created a doc the shows what i am attempting to do. Please see doc for my issue.
Any help would be greatly appreciated!!! :-)
Sincerely,
Keri File Attachment(s):
 Altova Mapforce_help.doc (32kb) downloaded 354 time(s).
|
|
Rank: Advanced Member
Joined: 8/19/2012
Posts: 149
Location: Ireland
|
Hi Keri,
Have you tried this?
ultrabeet attached the following image(s):
|
|
Rank: Newbie
Joined: 5/3/2013
Posts: 4
Location: CA
|
ultrabeet wrote:Hi Keri,
Have you tried this?
Hello ultrabeet,
Thank you for your reply. I am trying your suggestion. The Constants I am having trouble with.
please see attached docx
Thank you so much!!
File Attachment(s):
Altova Mapforce_ultrabeet.docx (50kb) downloaded 292 time(s).
|
|
Rank: Advanced Member
Joined: 8/19/2012
Posts: 149
Location: Ireland
|
Hi furrelkt,
Maybe this will shed you some light... Though I think there is enough info in the help
ultrabeet attached the following image(s):
|
|
Rank: Newbie
Joined: 5/3/2013
Posts: 4
Location: CA
|
ultrabeet wrote:Hi furrelkt,
Maybe this will shed you some light... Though I think there is enough info in the help
That is exactly what i have :-). However, it is still not formatting correctly.
The xls format is number coming in, and i have tried custom or I can make it a string (what do you suggest?).
For some reason this just isn't coming out correctly. Again, thank you for your help and suggestions.
File Attachment(s):
Altova Mapforce_help1.doc (83kb) downloaded 277 time(s).
|
|
Rank: Advanced Member
Joined: 12/13/2005
Posts: 2,856
Location: Mauritius
|
You should have said initially that your target file is Excel.
As you can read in documentation, MapForce doesn't support formatting in Excel - things like bold, italic, number or date formatting - this all has to be done externally, not in MapForce. MapForce can only output data in Excel.
There is only one possibility to make number output formatted with leading zeros in Excel - if you define your output cells to be strings and not numbers. In this case the text will be taken as is. This means though that you cannot use such numbers in Excel calculation, so presentation will be fine, but it might be not what you are looking for.
|
|
Rank: Newbie
Joined: 5/3/2013
Posts: 4
Location: CA
|
vlad wrote:You should have said initially that your target file is Excel.
As you can read in documentation, MapForce doesn't support formatting in Excel - things like bold, italic, number or date formatting - this all has to be done externally, not in MapForce. MapForce can only output data in Excel.
There is only one possibility to make number output formatted with leading zeros in Excel - if you define your output cells to be strings and not numbers. In this case the text will be taken as is. This means though that you cannot use such numbers in Excel calculation, so presentation will be fine, but it might be not what you are looking for.
Actually in my doc, I did say that the source was xls. (Xls - 0003165) and a pic of the xls column :-)
Thank you for your reply. I did however try the format as string in xls. I get the same results. I will keep playing around with this.
Thank you so very much for the suggestion.
|
|
|
guest |
