CLOB datatype

[GuptaN]

While performing any kind of transformation with CLOB datatype getting null in target.

Please guide on this.

Thanks,

GuptaN

[john_wang]

Hello @GuptaN ,

In general, yes, you cannot do any transformation for LOB columns, see User Guide Limitations  :

• The only supported transformation for LOB/CLOB data types is to drop the column
  on the target.

However I'd like to understand what's the exact needs about the transformation and it's better a sample to see if any work around.

Regards,

John.

[GuptaN]

For example :- abcd is a string and i need to replace d to z
while i am doing this getting null iin target

[lyka · Accepted solution]

Hello,

There is a replace function that you can use for string datatypes.

Replace() returns a string after replacing all occurrences of a given substring within the input string with another substring. The function is non-recursive and works from left to right.

Syntax:  

Replace(text, from_str, to_str)

Return data type: string

however i dont think this is applicable for lob columns. As what John said, 

• The only supported transformation for LOB/CLOB data types is to drop the column
  on the target.

https://help.qlik.com/en-US/qlikview/May2021/Subsystems/Client/Content/QV_QlikView/Scripting/StringF...

Thanks

Lyka

[Heinvandenheuvel · Accepted solution]

This question is often about just about replacing some (exception) characters like new-line, carriage-return or accented characters. If that's the case, then checkout the replaceChars internal parameter. Search this forum (classic search) for it. Or jump to : https://community.qlik.com/t5/Qlik-Replicate/remove-LF-line-feeder/m-p/1898082

Also note the LOB/CLOB manipulation is NOT available through UDT functions either (User Defined Transformation)

Hein.