Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
Thanks for everyone!