Business function to remove special characters from blob fields

metaedge

Member
Is there a business function to remove special characters (or search and replace) in blob fields? I know that there are limitations to string lengths for search and replace (b0400520 and also b1702080).

Thanks.
 
The blob/media data type is unlimited character length. This function takes in a string of length 40 for the input param.

Any other ideas?
 
metaedge,
I dont think you will be able to find a function which will support unlimited length of string unless you design your know.
Maybe you want to segment your blob and strip it thru the function one by one.

Thanks,
Chan
 
[ QUOTE ]
What special characters do you want to remove/replace?

[/ QUOTE ]

Trying to remove commas.
 
Hi Meta,

Can you try this BSFN B0400520. This is having length 1000 as input and Output Strings Parameters.
 
Ooops,
Yeah, commas are very special characters, like TAB, CR, LF, etc. including A, B, C....Z
 
Back
Top