topic Re: Substitute for SUBSTRING? in Application Development and Automation Discussions

Substitute for SUBSTRING?

Former Member — Thu, 11 Oct 2012 09:14:33 GMT

Hi,

here's a seemingly very simple question - but then, the "egg of Columbus" was easy and everyone could do it - afterwards 😉

So - I simply need to enter a WHERE condition into a SELECT command which queries the first character in a string (in my case, in the field TABNAME in DD02T, I don't want any tables beginning with '/').

Everywhere I look I read the correct syntax is [fieldname]+(length) - so I would write >> WHERE TABNAME+0(1) <> '/' << - right? Well, probably not, for that does not work. Neither does it when I use the proper OpenSQL syntax > DD02T~TABNAME <

Can anybody help me here?

Thanks a lot!

Best regards,

Sapperdapper

Re: Substitute for SUBSTRING?

Former Member — Thu, 11 Oct 2012 09:23:22 GMT

Have you tried

WHERE cond NOT LIKE '/%'.

Cheers,

Shambu

Re: Substitute for SUBSTRING?

Former Member — Thu, 11 Oct 2012 09:25:42 GMT

Hi Shambu,

for the >cond< in your example, would I write TABNAME (the actual fieldname)?

To answer, no I haven't tried because I didn't know ABAP could use the % as a wildcard.

Thanks a lot!

Regards,

Sapperdapper

Re: Substitute for SUBSTRING?

Former Member — Thu, 11 Oct 2012 09:28:33 GMT

Yes, Cond will be TABNAME for your case.

Re: Substitute for SUBSTRING?

Former Member — Thu, 11 Oct 2012 11:16:37 GMT

Perfect!

The limitation on texts in just one language brings me much more of a reduction as it seems - the limitation on DDLANGUAGE = 'DE' reduces from 1,8mio to approx. 124k and this from 124k to 123k, but that is just as well.

I guess that way or in a similar way I could also exclude tabnames that have an _ somewhere? I doubt that these tables would ever be used by the average SAP user...

Thanks a lot!

Best regards,

Sapperdapper