Extract all dollar amounts from text string

(0) Share

Report

Posted on by keylama

When receiving a new answer on a form, I would like to extract all dollar amounts from the multiple choice question. Then I want to sum those amounts and save the total it in a column of a sharepoint list

Specifically:

Question #16, multiple selection, asks to select books and each one includes its cost.

The resulting string for that question is as follows:

Savia Sociales 2 (Precio: $66.95);Savia Sociales-Cuaderno 2 (Precio: $29.95);Savia Ciencias 2 (Inglés) (Precio: $66.95);Con Buena Letra 2 (Precio: $21.60);Mi Primer Libro de Teoría y Solfeo Vol. 1 ($33.44);

I want to extract all prices $ and save the sum of all in a sharepoint item.

How can I do this?

Categories:

Using flows

I have the same question (0)

All responses (4)

Answers (1)

v-bacao-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @keylama ,

Please refer to these threads to extract data from text string:

https://powerusers.microsoft.com/t5/Building-Flows/Extracting-text-from-email/td-p/334919

https://powerusers.microsoft.com/t5/Building-Flows/Extract-text-from-body-of-an-email-and-create-new-rows-in-excel/td-p/104708

Best Regards,

Was this reply helpful? Yes No
VictorIvanidze 13,079 on at

Like (0)

Report
Copy link

Link copied!

Just parse a string.

Was this reply helpful? Yes No
keylama 20 on at

Like (0)

Report
Copy link

Link copied!

@v-bacao-msft
Thanks for the reply. I've done this before. My question comes specifically on how I get all amounts if I don't know how many they are.

If I misunderstood, my apologies.

Appreciated

Was this reply helpful? Yes No
Verified answer

v-bacao-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi @keylama ,

If these numbers are enclosed in parentheses and separated by semicolons, then you can use them as split points and then extract them. Even if the number of them is not determined, it does not affect the use of the Split() function. In fact, this is no different from the method mentioned in the links I provided. Find the split point, and then extract the data.

Best Regards,

Was this reply helpful? Yes No