Currency formats

[#1]

Hi everyone,

I came across a problem that I don't know how to solve.

I downloaded data and the amount looks like this:

Amount

38,362 EUR

39,398 EUR

37,210 EUR

37,210 EUR

$ -1,939

$ -2,332

$ -541

1,055,555 DKK

508,908 DKK

I would like to have a field with only amount and also additional field with currency, so that all lines look the same and it is easy to convert the amounts to diff. currencies..

Amount                           Doc.Currency

38,362                              EUR

-1,939                               USD

However, because curr. indicators are both at the beginning or at the back of the amount, I dont know how to handle this. Please help.

J.         

[kaushiknsolanki · Accepted solution]

Hi,

     You can try this way.

    Load

    Keepchar(Field,'1234567890') as Amt,

    Purgchar(Field,'1234567890-') as Curr

    From xyz.

Regards,

Kaushik Solanki

[Sokkorn]

Hi,

Check in the attached file.

Hope this help you.

Regards,

Sokkorn

[#4]

Thank you, it worked:)