Translating "," into "." - InfoPath Dev
in

InfoPath Dev

Translating "," into "."

Last post 06-14-2009 09:48 AM by steini. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next
  • 06-14-2009 09:02 AM

    Translating "," into "."

    Hello Infopath team

    could you tell me why this does not work?

    What I am doing is taking values from Timar_pr_mann a repeating text box that has numbers manually entered into it and summing them up into a function box.

    I would like for the users to be able to use either "," or "." as decimal separators and am trying to use the translate function translate(Timar_pr_mann,",",".") in the following formula but am having no luck fitting it in.

    DOM()/my:myFields/my:group1/my:verk/my:group6/my:group7/my:Timar_pr_mann[../my:Idnadarmadur = current()/ss:Cell/ss:Data]

     Is it possible to fit it in so it translates the , to . inside the sum function as I am trying above?

    thank you: steini

  • 06-14-2009 09:48 AM In reply to

    Re: Translating "," into "."

    Ok I had hardly finished clicking post when I found this one out :-)

     Of course I simply use the translate function in the Timar_pr_mann textbox it self so: translate(., ",", ".")

    Just did not think that a control could translate itself but that does not seem to be a problem.

     Thank you anyway and hope someone else can make good of this newbie question

Page 1 of 1 (2 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.