Replace() help

[mahitham]

Hi Experts,

Can any one please help me on below requirement.

I have field with below data in excel. Please help me to replace Not Applicable to n/a in the backend.

Number

4586

12463

28336

Not Applicable

536303

Thanks in advance

[OmarBenSalem · Accepted solution]

When u load it, load it as follow:

if(Number='Not Applicable','n/a', Number) as Number

[Chanty4u]

try this

load *, if(Number='Not Applicable','N/A',Number) as New;

load * Inline[

Number

4586

12463

28336

Not Applicable

536303

];