Page 1 of 1

Trim function clarification

Posted: Thu Apr 16, 2015 4:12 am
by vamsi.4a6
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")

Posted: Thu Apr 16, 2015 7:28 am
by qt_ky
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:

Code: Select all

Trim(columnname,("":'"':""),"A")
... and should be equivalent to:

Code: Select all

Trim(columnname, '"', "A")

Posted: Thu Apr 16, 2015 7:55 am
by chulett
Ah yes, was going to chime in a little earlier that it seemed a bit... nonsensical.