Split the text

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

Split the text

Postby marknicolai192 » Fri May 03, 2019 9:50 pm

Hi all,
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
marknicolai192
 
Posts: 1
Joined: Fri May 03, 2019 9:37 pm

Return to HanDBase General Discussion

Who is online

Users browsing this forum: No registered users and 2 guests

cron