visualdatatools.com Forum Index visualdatatools.com
Discussion for DataTank and DataGraph
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Converting text using a column / reading hex as a number

 
Post new topic   Reply to topic    visualdatatools.com Forum Index -> Getting Started
View previous topic :: View next topic  
Author Message
74rk



Joined: 12 Apr 2018
Posts: 12
Location: Tilburg, The Netherlands

PostPosted: Wed May 16, 2018 6:10 am    Post subject: Converting text using a column / reading hex as a number Reply with quote

I have an issue where I have to map two tables where each has a column with a MAC-address, but one uses this format: 00-01-02-03-04-05-06-0A and the other uses 000102030405060a

I want to be able to convert one or the other by using a table rather than search and replace as the tables get ammended quite frequently. I'm on the most recent beta version. Is there an option to do this? Maybe a uniform way to use regex in the expression column?

This raised also another question: can Datagraph handle different based numbers, like hex, binary, octal?
_________________
René Knuvers
Sr. Engineer - LUCROS Railway Engineering
Back to top
View user's profile Send private message Visit poster's website
David
Site Admin


Joined: 25 Nov 2006
Posts: 1967
Location: Chapel Hill, NC

PostPosted: Sat May 19, 2018 11:03 am    Post subject: Reply with quote

The "Number from Text Column" column can parse a specific portion. But there wasn't an option to understand binary/hex/octal numbers.

I added this and uploaded a new beta. You should get a notification when you launch the beta. In your case you will nee 8 columns that each extract a number from a portion of the text string. This column type can only be created in the beta. I added a menu to select between decimal, hexadecimal, octal and binary. Currently it only works for integers and not fractions.

David
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Post new topic   Reply to topic    visualdatatools.com Forum Index -> Getting Started All times are GMT - 3 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group