How to substring a textfield

For HanDBase related topics that are not specific to one platform.

How to substring a textfield

Postby kluesi » Wed Jun 20, 2018 7:46 am


I want to insert a duration field where I can write duration values like "00:15" (15 minutes) but also "36:00" (36 hours). So I cant take the time field because it shows only 23 hours. So I think I put a text field in the dataset and extract the part before and the part after the ":" and put it into two separate integer fields. But I found nothing like a substring function. How can I split this text?

Thanks Kluesi
Posts: 3
Joined: Tue Jun 19, 2018 9:23 am

Re: How to substring a textfield

Postby mjhanna » Wed Jun 20, 2018 10:35 am

You posted this question twice, I replied to the other post.
(Only a user and not affiliated with DDH Software, but working with computer databases for over fifty years.)
Posts: 159
Joined: Tue Oct 15, 2013 10:56 am
Location: New Mexico

Return to HanDBase General Discussion

Who is online

Users browsing this forum: Bing [Bot] and 0 guests