In user variable activity following derivation is defined
Field(Trim(EReplace(Get_Extract_DTTM_Param.$CommandOutput,@FM,""),("":'"':""), "A") ,"|",2).
Can anybody explain what trim will do in above case.basically i did not understand below part
Trim(columnname,("":'"':""),"A")
Trim function clarification
Moderators: chulett, rschirm, roy
It would appear remove all occurrences of a double quotes. It also has a lot of extra "stuff" in the function call that is not needed. Use Notepad or code tags to see:
... and should be equivalent to:
Code: Select all
Trim(columnname,("":'"':""),"A")
Code: Select all
Trim(columnname, '"', "A")
Choose a job you love, and you will never have to work a day in your life. - Confucius