Parsing $ value from field including both strings and integers

[Holly_Matthews]

Hey there,

I’m trying to parse out the $ value from a field containing both integers and strings.

Example

The input I currently have is in the Field named ‘Description’ and the output I’m looking for is for Field name, ‘$$’

I’m aiming to do this via custom dimension or the SQL runner

For the custom dimension, have broken the problem down and created dimensions for the following:

• Contains $ (YES/NO)
• Position of the $ sign
• Substring using the position of the $ --> the problem here is that have to identify a length and all of the values are different lengths.

Any help would be appreciated!