topic Re: ABAP CDS - string function to remove spaces? in Application Development and Automation Discussions

ABAP CDS - string function to remove spaces?

vonglan — Tue, 19 Apr 2022 10:46:48 GMT

I would like to create a CDS that provides a template for creating CDS from tables.

For this purpose, I would like to remove the spaces in database field dd04t.scrtext_l (long text of fields).

How can I do this?

The simple

replace( dd04t.scrtext_l, ' ', '' )

does not work. Maybe the "trailing spaces" in the second argument are removed.

Backquotes to preserve the space are not allowed.

Workarounds like the following also did not work:

cast( '' as abap.char( 1 ) ) ,
concat( '', ' ' ), // I found this in SAP course material
concat_with_space( '', '', 1 ),

Is there no way to do this in CDS? (Of course, I can always use ABAP.)

Update: I published the ABAP report for the task here:

Utility Report to provide the long field names when creating a new basic CDS | SAP Blogs

Re: ABAP CDS - string function to remove spaces?

vonglan — Tue, 19 Apr 2022 14:44:34 GMT

sandra.rossi :

1) would you mind explaining how exactly you searched ? I did not find anything related to removing spaces in core data services

2) the approach with char(32) did not work for me (syntax error). Did you mean

                         cast( '' as abap.char( 32 ) ) ,

That also did not work

Re: ABAP CDS - string function to remove spaces?

Sandra_Rossi — Tue, 19 Apr 2022 18:11:56 GMT

I'm so sorry, I completely missed that your question was about CDS, and I was looking at SQL/SQLScript/AMDP (in SQL, replace also didn't work for removing spaces, the SQL function CHAR(32) worked), so please forget my previous comment. I just deleted it to not confuse future readers.

Re: ABAP CDS - string function to remove spaces?

Sandra_Rossi — Tue, 19 Apr 2022 19:19:53 GMT

In fact, just thinking again, if we create a CDS Table Function whose AMDP does REPLACE( dd04t.scrtext_l, char(32), '' ) (here CHAR(32) OR NCHAR(32) will work, being a HANA SQL function), I think it should work.

Re: ABAP CDS - string function to remove spaces?

Former Member — Fri, 22 Apr 2022 19:08:16 GMT

Are you talking about leading or trailing spaces and other characters? What kind of value is it?

Try these keywords see which one fulfills your requirement- LTRIM or RTRIM, LEFT, RIGHT

https://help.sap.com/doc/abapdocu_750_index_htm/7.50/en-US/abensql_functions_string.htm

Re: ABAP CDS - string function to remove spaces?

vonglan — Tue, 26 Apr 2022 13:20:16 GMT

no, it is not about trailing of leading spaces