Hi All, I am facing problem in converting time format, i.e. I have time like "0:30:10" coming from source SFTP and i want to convert it into 0.5 this format in my target file. Can anybody help me with to do this in map function..
You might need to elaborate here. What is 0.5? Half of 1 hour?
To my knowledge there is not an exclusive function in Boomi that will handle this. You will need to use custom scripting to accomplish this conversion. You may find below articles useful:
swing - Convert time field H:M into integer field (minutes) in JAVA - Stack Overflow
java - Convert integer minutes into String "hh:mm" - Stack Overflow
Generally speaking, you would want to split the string 00:30 at the ":" and calculate each string value to output the integer you are looking for (including the rounding you desire). Unfortunately, my scripting knowledge is limited so I cannot provide a quick example for this scenario, but I hope the links provided will give you a good start.
On Thu, Mar 23, 2017 at 2:28 AM, john_yocum067395 <
On Thu, Mar 23, 2017 at 12:11 PM, Rudal Gawande <email@example.com>
what is your source time? is it 12 or 24 hr format?
Retrieving data ...