expression help

[#1]

Hi,

Please see app attached.

Need help with the script so it renames certain responses.

'email' needs to be included in EMAIL as this is the correct field. Simiarly 'letter, 'Letter' need to be included in LETTER. 'Phone', 'phone' and 'tel' need to be under PHONE and 'text' needs to be in TEXT.

Appreciate any assistance.

Chris

[sudeepkm · Accepted solution]

you may use

LOAD upper(Contact) as Contact,

     Count

FROM

[israrkhan]

see the attachment.

hope it helps..

[Anonymous]

Try below,

Upper(Replace(Upper(Contact), 'TEL', 'PHONE'))

[dharmarasu]

hi,

see the attachment

Regards,

Dharma

[ashfaq_haseeb]

Hi,

May be like this.

Regards

ASHFAQ

[ashfaq_haseeb]

Hi Chris.

look at my application With Sadeep and all suggestions

You will not get tel under PHONE as specified below.

'Phone', 'phone' and 'tel' need to be under PHONE

Regards

ASHFAQ