Parse string to numbers

[wenyg]

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

[ShankerV · Accepted solution]

Hi @wenyg 

One way to do is.

Many thanks

Shanker V

[ShankerV · Accepted solution]

Hi @wenyg 

Another way to do this using regex.

(\d{4})

Many thanks

Shanker V

[binuacs · Accepted solution]

@wenyg Another way of doing this

[MarqueeCrew]

@wenyg ,

 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