Hw to extract values

studio

#1

how to extract the value from string where
input String : “10 11301CD1 2 Irrigation Adaptor, for machine
cleaning, reusable,
for use with Flexible Intubation Video
Endoscopes 11301 BNX and 11302 BDX
Country of origin: EE”

Output String: “Irrigation Adaptor, for machine
cleaning, reusable,
for use with Flexible Intubation Video
Endoscopes 11301 BNX and 11302 BDX”
Where only "Country of origin " string is fixed. Also the length for characters may vary.


#2

Hi,

Check this workflow, you can use regex to extract the string after 3 spaces, and the substring to get the string before country of origin. Note this is case sensitive. so please take care.

ExtractStringForNumbers.xaml (6.4 KB)