my filed data = USD300 , how to read only 300 ?

[#1]

Hi All

My raw data price list is string , i need to read only the number , can some one give me the script.

Now my script is like this , it will read USD300 :-

     [List Price] AS LIST_PRICE,

Paul

[#2]

use Subfield(LIST_PRICE,'USD',2)

OR

purgechar ( LIST_PRICE,'USD' )

[er_mohit]

use num function

num([LISTPRICE]) as [LIST_PRICE]

[jagan · Accepted solution]

Hi,

Use

purgechar ( LIST_PRICE,'USD' )

or

=Replace( LIST_PRICE,'USD', '' )

Regards,

Jagan

[#5]

Hi,

This will work simply

=Mid('USD300',4)

Regards,

Saritha xavier

[#6]

Both work fine Shi Thank a lot

[#7]

This not able to work. Thank you too for trying.

[#8]

you even better Jagan , you dare to try replace.

[#9]

Hi Sar

I doubt your will work , as in your script there it no List Price.

Paul

[#10]

new:

load mid(LISTPRICE,4)as PRICE
Resident USD;