XSL Formatting Price of Awin Feeds

[accelerator]

Hi

In the Price fields of the Awin feeds I've noticed that some merchants include a currency code (i.e. GBP123.45) whereas others don't and it's just 123.45.

I want to transfer this data into a MySql database without the currency code in front. As I have to apply an XSL transform to the data first, can anybody tell me the way to remove the ccy code with XSL?

Thanks

Accelerator

[jonsp]

Is it always going to be GBP? If so strip out those 3 letters
<xsl:value-of select="translate(FieldName, 'GBP', '')"/>

If you need to take other actions depending on GBP UDS etc post back and I'll give an alternative.

Jon

[accelerator]

Hi Jon

Thanks for your reply. It is only sometimes that the GBP appears in front. What I think I need is a conditional XSL processing statement that if the GBP is there, it gets stripped off, otherwise the field can just be processed "as is".

I am looking at the:

<xsl:choose>
<xsl:when test="">
<xsltherwise>

functionality, but I don't know how to format the test statement to get this done.

Many thanks for your input.

Rgds

Accelerator

[jonsp]

OK in that case use what I posted up - translate works the same as replace in most languages it will just strip out a string, in this case 'GBP' if it exists and if not do nothing. The only reason I made it sound more complicated is I thought you might need to do something else if a different currency code appeared.

Jon

[accelerator]

I've tried this in my xsl file, but it's not working:

<Price><xsl:apply-templates select="translate(Price, 'GBP', ")"/></Price>

Any ideas where I'm going wrong anyone?

Thanks

Accelerator

[accelerator]

Whoops, sorry guys, found my error, I needed xsl:value-of rather than xsl:apply-templates:

<Price><xsl:value-of select="translate(Price, 'GBP', '')"/></Price>

Thanks for your help jonsp.

Cheers

Accelerator