Parse string to numbers

Hi, How do parse P1000 into 1000? It will always start with "P" and following with 4 digits.

Developer Tools

Accepted answers

One way to do is.

Many thanks

Shanker V

Another way to do this using regex.

(\d{4})

Many thanks

Shanker V

@wenyg Another way of doing this

Extract_Numbers_100423.yxmd

All comments

One way to do is.

Many thanks

Shanker V

Another way to do this using regex.

(\d{4})

Many thanks

Shanker V

@wenyg Another way of doing this

Extract_Numbers_100423.yxmd

if the string is always P followed by 4 digits, the data cleanse and Regex are expensive overkill.

right([field1],4) is the easiest way.

cheers,

mark

Quick Links

Tags

This months top contributors