Forum Discussion

jnpb's avatar
jnpb
Helper I
3 years ago
Solved

Extracting $amount from Notes field

I have a table with a Notes field that contains varying text, but each with a dollar value expressed as $nnn.nn . The amount varies but always includes decimals.  How would I go about extracting t...
Need Help
  • parry2k's avatar
    parry2k
    3 years ago

    jnpb the solution v-yanjiang-msft provided is basically looking to extract the value between $ and "For Order" and in case it didn't work because that row doesn't meet the criteria, maybe change it to this:

     

    Text.BetweenDelimiters([Column1], "$", " ")

     

    ✨ Follow us on LinkedIn and  to our YouTube channel

    I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make effort to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

     

    ⚡ Visit us at https://perytus.com, your one-stop shop for Power BI-related projects/training/consultancy.

v-yanjiang-msft's avatar
v-yanjiang-msft
Community Support
3 years ago

Hi jnpb ,

What do you mean non numerical characters are through, like this?

If this is the case, you should right click the column and select Replace Values, replace the character with blank.

Hope it helps!

 

Best Regards,
Community Support Team _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

jnpb's avatar
jnpb
Helper I
3 years ago

I ended up doing this, though the volume of instances where text characters made it through and had to be removed was more than I'd liked - it did help solve for the issue however. Thank you so much!