Unanswered

Extract numeric value from the string

(0) Share

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:

General topics

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

v-hanytian-msft Microsoft Employee on at

Like (1)

Report
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,484 on at

Like (1)

Report

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