problem in displaying single quotes

[Former Member]

Hi,

I have applied the quotes but its still not working in the way I want. Like,

concatenate v_constantname '= ' ''''itab_split-constantname'''' into v_string2 separated by space.

concatenate v_linenum '= ' ''''itab_split-linenum''''

into v_string1 separated by space.

.....

concatenate v_string1 ' and ' v_string2 into itab_where-line separated by space.

This is the code and the concatenation is done for a dynamic where clause. The value of itab_split-linenum and itab_split-constantname should be within single quotes, e.g., it should be

C_LINE_NUM = '000047' and

C_NAME = 'CR_Z001_EMPLOYEE_COMPANY'

But it is coming like the following:

C_LINE_NUM = ' 000047 ' and

C_NAME = ' CR_Z001_EMPLOYEE_COMPANY '

There should not be any space between the value and the quotes. How to do it?

Thanks in advance,

Sangeeta.

[Former Member]

Hi,

I have applied the quotes but its still not working in the way I want. Like,

concatenate v_constantname '= ' ''''itab_split-constantname'''' into v_string2 separated by space.

concatenate v_linenum '= ' ''''itab_split-linenum''''

into v_string1 separated by space.

.....

concatenate v_string1 ' and ' v_string2 into itab_where-line separated by space.

This is the code and the concatenation is done for a dynamic where clause. The value of itab_split-linenum and itab_split-constantname should be within single quotes, e.g., it should be

C_LINE_NUM = '000047' and

C_NAME = 'CR_Z001_EMPLOYEE_COMPANY'

But it is coming like the following:

C_LINE_NUM = ' 000047 ' and

C_NAME = ' CR_Z001_EMPLOYEE_COMPANY '

There should not be any space between the value and the quotes. How to do it?

Thanks in advance,

Sangeeta.

[Former Member]

like that

concatenate '"' <fs> '"' into str.

[Former Member]

do like this

concatenate v_constantname '=' into v_string1 separated by space.

concatenate `'` itab_split-constantname `'` into v_string2.

concatenate v_string1 v_string2 into v_string3 separated by space.

concatenate v_string3 ' and ' v_string4 into itab_where-line separated by space. "v_string4 must also be built on same lines.

Regards,

Ravi

[Simha_]

Hi,

Use <b>CONDENSE</b> statement to condense the blank spaces for v_string2...

It will do for u..

Cheers,

SImha.

<b>Mark all the helpful answers..</b>

[Former Member]

hi Sangeetha

concatenate '''' itab_split-constantname '''' into v_string1.

concatenate '''' itab_split-linenum '''' v_string2.

concatenate v_constantname '=' v_string1 v_linenum '=' v_string2 into itab_where-line separated by space.

Hope this 1 helps.

Regards

-

---

Sachin Dhingra

[Former Member]

Hello Sangeetha,

Save the single quotes as a TEXT Symbol and concatenate.

If useful reward.

Vasanth