match first 3digits in a field

[bsbernabe]

Hello There,

My concern is like this 

if 3 digits left of Previews No. is match in Current No. of 3 digits left, how to display or get equal to Current No. ?

Below is a sample data:

Previews No.	Current No.
270	270R
407	407R
803	803R

The output should be like below:

Current No.

270R

407R

803R

How can i do this  can anyone help?

Best Regards,

Bing

[mahaveerbiraj · Accepted solution]

Hello Bsbernade,

Could you please try below  syntax in script ,

 If( Left([Previews No],3)= Left([Current No],3), [Current No]) as [Current No]

Thanks & Regards 

Mahaveer 

[bsbernabe]

Great Thank you so much for fast support.