Answered

get particular text from a string

(0) Share

Report

Posted on by kanha123_456

hi , i want to get the code value from below text string , how can i do it ........Expected result should be Code : I83.892( any value)

Primary*

Code:

I83.892

Description:

VARICOSE VEINS LT LWR EXT WITH OTH COMPLICATIONS

Other Diagnosis Text:

Secondary

Code:

I87.2

Description:

VENOUS INSUFFICIENCY CHRONIC PERIPHERAL

Other Diagnosis Text:

Delete

Code:

M79.605

Description:

PAIN IN LEFT LEG

Other Diagnosis Text:

Delete

Code:

M79.662

Description:

PAIN IN LEFT LOWER LEG

Other Diagnosis Text:

Delete

Add Diagnosis

Categories:

Power Automate Desktop

I have the same question (0)

All responses (4)

Answers (0)

Sort by

Suggested answer

eetuRobo 4,484 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Use Parse Text with Regex enabled.
Text to find regex: Code:\s*([A-Z]\d{2,3}\.\d+)

That returned this from the text you gave:

Was this reply helpful? Yes No
kanha123_456 43 on at

Like (0)

Report
Copy link

Link copied!

Hi , as this is the solution but this solution is not working if the code value is not in decimal .

could u plz tell the solution if decimal value is not there then how can we get the code value

Was this reply helpful? Yes No
eetuRobo 4,484 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Good to hear that it worked

:Try this regular expression to get also ones without decimal
Code:\s*([A-Z]\d{2,6}(?:\.\d+)?)

ChatGpt created it with this explanation

Was this reply helpful? Yes No
Suggested answer

harish_sada 53 on at

Like (0)

Report
Copy link

Link copied!

you can use this Regex: Code:\s*([A-Za-z0-9\.]+)

Was this reply helpful? Yes No