help me in triming the values?

[durgabhavani]

I need to remove the field value SYST: in the information field.

Information

SYST: ACCOUNTS

SYST: ACCOUNTS

SYST: ACCOUNTS

SYST: ACCOUNTS

SYST: ACCOUNTS

SYST: ACCOUNTS

SYST: FINANCE

SYST: FINANCE

SYST: FINANCE

SYST: FINANCE

SYST: FINANCE

help me in trimming.

[jagan]

Hi Durga,

Simply use the Replace() like below in script

TableName:

Load

Replace(Information,'SYST:','') as Information

From DataSource;

Hope this helps you.

Regards,

Jagan.

[durgabhavani]

Thanks for everyone!