Transform

How to transfer A into B

Expense Type

Transportation 3% – Online ride-hailing (China Only)

Transportation 9% – Train (China Only)

Expense rate

Accepted answers

Hi phoebe_90

You can use a RegEx tool and use the expression \d+% with output method as Tokenize

Thanks!

You can use the following regular expression:

.*\s(\d*%)\s.*

Regular Expression Tool:

Note, the regex parses #% and ##% and ###% it does not handled decimal points.

Hope this helps,

Arnaldo

Use Regex Tool and try this formula \d+%

1- By RegEx tool of Parse method:

([0-9.]+?%)

2- Use formula :

Substring([Expense Type],FindString([Expense Type], ' ') + 1,FindString([Expense Type], '%') - FindString([Expense Type], ' '))

录制_2023_07_31_12_27_39_302.gif

@phoebe_90 The regex tokenize would do the trick

Hi phoebe_90

You can use a RegEx tool and use the expression \d+% with output method as Tokenize

Thanks!