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

Hi

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
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.
Michael
(Only a user and not affiliated with DDH Software, but working with computer databases for over fifty years.)
mjhanna
 
Posts: 160
Joined: Tue Oct 15, 2013 10:56 am
Location: New Mexico

Re: How to substring a textfield

Postby sachinkhanna48 » Sun Aug 12, 2018 2:59 am

mjhanna wrote:You posted this question twice, I replied to the other post.


sir can you please give the url of the post so I can read
sachinkhanna48
 
Posts: 1
Joined: Sun Aug 05, 2018 11:33 am


Return to HanDBase General Discussion

Who is online

Users browsing this forum: Google Feedfetcher and 0 guests

cron