Trim function clarification

vamsi.4a6 · Post by **vamsi.4a6** » Thu Apr 16, 2015 4:12 am

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")

qt_ky · Post by **qt_ky** » Thu Apr 16, 2015 7:28 am

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")

chulett · Post by **chulett** » Thu Apr 16, 2015 7:55 am

Ah yes, was going to chime in a little earlier that it seemed a bit... nonsensical.