Quoted String is too long Msg

HCL Domino Domino Forum
1

Hello… I use a very long string @left function (May be 3 - 4Kb) and I get this message ‘Quoted String is too long’.

I tried it in evaluate first & didnt work and when I tried in a plain field I got this mg.

Can anyone tel, how to get around this…?

2

Subject: Quoted String is too long Msg

Your string literal is too long for the formula. But if you are using LotusScript, why are you evaluating a formula when there are Left and Strleft in the LotusScript language?

3

Subject: RE: Quoted String is too long Msg

Hi Stan,

The reason why I used evaluate is, the @left parameter is actually a variant value (I implode it and use) so If I want to take all the values of a particular string (ex:- A~1 : A~0 : B~6 so on…) in one go, I felt this is easier, instead of looping thro’ and getting the values.

I use it like this :- sFormula = {@trim(@left(@right(“} & Implode(myVariant,”#“) & “#” & {”;“} & Cstr(v) & {”);“#”))}

Cstr(v) has my target string.

4

Subject: RE: Quoted String is too long Msg

… and when you implode it, it is too long to be used in a formula. Hmm. Seems to me that not imploding it would be a good answer, but that would mean creating an item on a NotesDocument in order to use Evaluate. Or you could just bite the bullet and loop, which is at least as clean a solution.

5

Subject: RE: Quoted String is too long Msg

Stan, I could have have used this

Strleft(Strright(Implode(myVariant,“#”) & “#”,Cstr(v)),“#”)

instead of my formula…! (what you suggested initially)

Its works like a gem now…