topic Re: STRLEN in Application Development and Automation Discussions

STRLEN

Former Member — Tue, 04 Dec 2007 08:00:53 GMT

Hi,

Cosider the following scenario:

I have filename stored in l_file (type string)

I want to determine if the last four chararcters are .xls

How do i proceed after i determine the length with strlen( l_file ). ???

Re: STRLEN

Former Member — Tue, 04 Dec 2007 08:03:54 GMT

Hi,

Hi use CS operator in the if condition.

eg if l_file cs '.xls'.

endif

regards,

Santosh Thorat

Re: STRLEN

Former Member — Tue, 04 Dec 2007 08:04:12 GMT

Hi,

if string length = 10.

data pos type i.
pos = strlen - 4.
last_four = i_file+pos(4).

Regards,

Satish

Re: STRLEN

Former Member — Tue, 04 Dec 2007 08:07:08 GMT

data: l type i.

l = strlen( l_file ) - 5.

if l_file+l(3) = '.xls'.

endif.

Re: STRLEN

former_member386202 — Tue, 04 Dec 2007 08:07:33 GMT

Hi,

Split into 2 strings at '.' using split statement then copmare second string if it .xls or not

SPLIT f AT g INTO h1 ... hn.

Regards,

Prashant

Re: STRLEN

Former Member — Tue, 04 Dec 2007 08:08:56 GMT

Hi,

You can try the below logic instead of STRLEN.

SPLIT filename AT '.' INTO file1 extension.

if extension = 'xls'.

Proceed further.

endif.

If you want to use STRLEN.

flen = STRLEN(filename).

flen = flen - 5.

exten = filename + flen(4).

if exten = '.xls'.

xxxxxxxxx

endif.

Re: STRLEN

matt — Tue, 04 Dec 2007 08:32:58 GMT

SPLIT and CS are nice ideas, but won't work with all strings. E.g.

mymalformedfilename1.xlsxyz - will pass with CS, but shouldn't.

mymalformedfilename2.xls.xls - will fail with SPLIT, but shouldn't.

Also, strlen with STRING types includes any following spaces, so they need to be removed first using condense.

How about this?

PERFORM check_xls USING: `x.xls`,
                         `mymalformedfilename1.xlsxyz`,
                         `mymalformedfilename2.xls.xls`.

*&---------------------------------------------------------------------*
*&      Form  check_xls
*&---------------------------------------------------------------------*
FORM check_xls USING i_fn TYPE string.

  DATA: l_fn  TYPE string,
        l_len TYPE i.

  WRITE: / i_fn.

  l_fn = i_fn.
  CONDENSE l_fn.
  TRANSLATE l_fn TO UPPER CASE.

  l_len = STRLEN( l_fn ).
  SUBTRACT 4 FROM l_len.

  IF l_fn+l_len(4) EQ '.XLS'.
    WRITE: / 'Is valid'.
  ELSE.
    WRITE: / 'Is not valid'.
  ENDIF.

ENDFORM.

matt

Re: STRLEN

Former Member — Tue, 04 Dec 2007 08:56:09 GMT

DATA F(20) VALUE 'file.xls'.

SEARCH F FOR '.xls' .

sy-subrc will be zero as .xls is found.

also sy-fdpos contains the offset.

Re: STRLEN

matt — Tue, 04 Dec 2007 09:03:28 GMT

> DATA F(20) VALUE 'file.xls'.

> SEARCH F FOR '.xls' .

> sy-subrc will be zero as .xls is found.

> also sy-fdpos contains the offset.

Fails on file.xlsxyz

matt

Re: STRLEN

Former Member — Tue, 04 Dec 2007 09:24:10 GMT

its working fine.i checked it.

still gives sy -subrc = 0.

and sy-fdpos = 4.