replace

[#1]

how to replace the '<=x<' symbol with '-' function using replace function?

[SunilChauhan]

Replace(fieldName,'<=x<' ,'')

hope this helps

[Kushal_Chawda]

try like this

Replace('<=x<abcd','<=x<','-')

[#4]

new:

LOAD Region,

     Year,

     Products,

     Sales,

     class

     ([Sales],30) as Salesrange

FROM

(biff, embedded labels, table is Sheet1$);

A:

    LOAD * ,  Replace(Salesrange,'<=x<' ,'-')

      Resident new;

      DROP Table new;

here replace function is not working y??

[Colin-Albert · Accepted solution]

Try this

new:

LOAD Region,

     Year,

     Products,

     Sales,

     replace ( class(Sales,30) ,'<=x<' ,'-') as Salesrange

FROM

(biff, embedded labels, table is Sheet1$);

[anbu1984]

Check if you have spaces in between string '<=x<' in your input

Can you provide sample data for which replace didn't work

[#7]

Hi siva,

try this

new:

LOAD Region,

     Year,

     Products,

     Sales,

     class

     ([Sales],30) as Salesrange

FROM

(biff, embedded labels, table is Sheet1$);

A:

    LOAD * ,  Replace(Salesrange,'<=x<' ,'-') as Sales_Range

      Resident new;

      DROP Table new;

or

A:

    LOAD * ,  Replace( ([Sales],30),'<=x<' ,'-') as Sales_Range

      Resident new;

[#8]

hey, siva prasad

it's very simple.

replace(fieldname,'<=x<','-') as fieldname

cheers,

kunal bhattacharjee

[SunilChauhan]

Replace(trim(Salesrange),'<=x<' ,'-') as yourfieldname

[SunilChauhan]

or try to copy <=x< from you Salesrange in replace above

hope this helps