How to regex a value from string and convert as metric in CJA?

[gmadala]

Hello, 
I have a question specifically in CJA data view settings, would like some help. 
I have a string that has the value event345=12 

I have used regex to extract the value 12 and deduplicated this dimension to make it as my metric. 
However since the schema datatype was string its still treated as the same rather making the metric to store the value 12 in it. 
Could someone help me figure out a hack to achieve what I need without the use of derived field ? reason I am not using derived fields are, I guess we get only 100 derived fields as a limit. 

Thanks

[MandyGeorge]

Currently in CJA there are two ways to turn a dimension into a metric - derived fields and component settings. 

If you use component settings to turn a dimension into a metric, it will give you a count of many times that dimension fired, like a counter event. There isn't a way to turn it into a numeric event and have the value in the field become the metric itself (ex, return "12" instead of the number of times "12" fired). Right now, the only way to do that would be through derived fields. It might be worth reviewing your derived fields and see if there are any that can be accomplished by using the component settings instead so that it can free up some space to do what you need to. 

[gmadala]

I agree, the reason I want to limit use of derived fields is because I have a limited derived fields that I can create(~100).
Would like to know if there are any other hack.

[Josh__Stephens]

Hi @gmadala 

I've run into this same issue and I do not believe there's currently a way to extract a number from a string and cast it was an integer.  

With that being said, I'm building a Report Builder project that accomplishes similar results in Excel.  I'd recommend taking a look that that if you haven't already.

Wouldn't it be nice if Adobe added the ability to cast as integer soon? 

[gmadala]

Thats what I figured out. I wouldnt want to use report builder. Moving away from excel for reporting and rather use CJA to visualize. Thats my current challenge.