topic Re: Text to Value in Data Hub

Text to Value

PBaxter — Thu, 03 Nov 2022 16:55:03 GMT

Hi,

Using Ops Hub to transform some incoming string data (in a text field) like:

"25% increase"

"-10% decrease"

I can easily use the replace function to strip the " % increase" and " % decrease" text to create data "25" and "10"

But then I want to copy that output into a number field, and I can't see a function in Ops Hub to do a simple text to number transformation - e.g. value() or parseInt()... etc

Any suggestions?

Thanks!

Re: Text to Value

crispyGTM — Thu, 03 Nov 2022 17:53:04 GMT

@PBaxter HubSpot will prevent you from copying fields of different types over to one another.

Alternatively, you could change your initial string data to be in positive or negative value formats - and change the text field to a number instead. you could assume that positive values mean increases and negative values mean decreases. That would then allow you to copy the value to a number field.

Re: Text to Value

Teun — Thu, 03 Nov 2022 19:13:21 GMT

@PBaxter You could achieve this with a coded action, simply use the value you got from your format data action in your coded action and try the following:

exports.main = async (event, callback) => { const valueToConvert = event.inputFields['formula_result_output']; const newNumberValue = Number(valueToConvert); callback({ outputFields: { newNumberValue: newNumberValue } }); }

Re: Text to Value

Teun — Thu, 03 Nov 2022 19:14:35 GMT

Or with even less code:

exports.main = async (event, callback) => { callback({ outputFields: { newNumberValue: Number(event.inputFields['formula_result_output']) } }); }

Re: Text to Value

PBaxter — Fri, 04 Nov 2022 11:55:40 GMT

You guys on here are so awesome. I'd wondered if a bit of code could address this, but it would have taken me hours to work out how to do those input/output pieces - thanks so much for the screenshots!

I have my solution working now after a couple of hours doing and testing the workflows.

Thanks again.