This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I have data that represents the hours in a day, however I need to trim 2 zeros off the data. Hour 1 currently looks like 100, hour 10 looks like 1000, and hour 24 looks like 2400. How can I trim the 2 zeros off the end? I tried
But that results with hour 1 being 10 and instead of 1.
But that resulted with hour 10 being 1 instead of 10.
@marlylove you can put a "IF condition" for the TRIM condition so that it applies only when the length is greater than 3 for example or 4 depending upon your use case. Please let me know if this works.