Transform

[phoebe_90]

How to transfer A into B

A

Expense Type

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

Transportation 9% – Train (China Only)

B

Expense rate

3%

9%

[ArnaldoSandoval]

Hi @phoebe_90 

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

[BRRLL99]

Use Regex Tool and try this formula \d+%

[flying008]

Hi, @phoebe_90 

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], ' '))

[binuacs]

@phoebe_90 The regex tokenize would do the trick

[grazitti_sapna · Accepted solution]

Hi phoebe_90

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

Thanks!