web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Extract numeric value ...

Power Automate

Answered

Extract numeric value from the string

(0) Share

Report

Report

Posted on by comangus13

I have created a "Parse Json" to extract the values from my CSV file. the extraction is working fine, however, I need to get only the numerical value from a particular string, to insert one of the numeric values on my SharePoint list

The Case Number returned is

"Case Number": "\"<div><a href=\"\"https://customercare-mastercard.my.salesforce.com//lightning/r/Case/5003u000016GRmiAAG/view\"\" target=\"\"_blank\"\">03679142</a></div>\"",

I am trying to remove everything from the string but the number 03679142, which is the one I need to insert on my SharePoint list

I have tried split() and replace but can't make sense of what I am doing, I would appreciate any help

Categories:

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Verified answer

v-hanytian-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Hi @comangus13,

We made a sample for you.
slice(outputs('Compose'),add(nthIndexOf(outputs('Compose'),'>',2),1),nthIndexOf(outputs('Compose'),'<',3))

Hope this will help you,
Best Regards,
Tina

Was this reply helpful? Yes No
Sundeep_Malik 6,499 on at

Like (1)

Report
Copy link

Link copied!

Hey @comangus13

I have added your data in a compose action. Then I have used two split functions.

Function used:

split(split(outputs('Compose'),'_blank\"\">')[1],'</a>')[0]

So firstly I am splitting it first _blank\"\"> and taking the 2nd element or 1st index of it.

After that I am using 2nd split on </a> and taking 0 index of it or 1st element.

Final Output:

Was this reply helpful? Yes No

Join the conversation