want to select data form a concatenated field in Alteryx

[sahasanb]

Column Value : SSSS Design # 1 1 of X (28%)

Output : 28

Column Value : aaa (55%)

Output : 55

[chrissgtan]

@sahasanb Please try the attached yxmd file.

Thanks,
Chris

[sahasanb]

Input : Oxxxxxxx
Design #1 - 1 of x
10%
OutPut 10

Input :
Sxxxxx
Design # 1
1 of X
(28%)

OutPut 28

Input : Sxxxx 50mg
Output 0

Input Simc 50

[sahasanb]

No man its not working as

Input : Oxxxxxxx
Design #1 - 1 of x
10%
OutPut 10

Input :
Sxxxxx
Design # 1
1 of X
(28%)

OutPut 28

Input : Sxxxx 50mg
Output 0

Input Simc 50