SAP BODS | String manipulation queries.

[#1]

Here is the one requirement for string manipulation. Please share your feedback on the same.

Rule for Default name: Break at the last space prior to the 35th character (i.e. if the length is more than 35 char, we want only complete sentence/word)

For example if default name : Indian institute of management Bangalore 

which is more than 35 char, So first 35 letter will be ~ Indian institute of management Bang, But we want only complete words as name ’ Indian institute of management ’. we don’t want word ‘Bang’ at last.

Overflow of the name will be managed in Name2 so no issue with trimJ

I have put temp fix to this requirement and its working fine. Please suggest if you have any other logic to implement same in SAP BODS

decode(length(Default_Name) > 35, rtrim( substr(Default_Name, 1, 35), '()qwertyuiopasdfghjklzxcvbnmQWERTYUIOPASDFGHJKLZXCVBNM1234567890-,.&*":;<>?/#@' ), Default_Name)

Thanks,

Abhishek

[former_member208363]

I agree your decode function solution .