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

Return to HanDBase General Discussion

Who is online

Users browsing this forum: Google [Bot], Majestic-12 [Bot] and 0 guests