topic Re: To Split a variable to get the date. in Application Development and Automation Discussions

To Split a variable to get the date.

Former Member — Mon, 05 May 2008 10:09:07 GMT

Hi all,

I have a variable 'file1'.This variable stores the names of the pdf files located in SAP directory.

The name of the file is like:'PDFST0000098357US81042008',

which containg order no ,sales org, month and date of that file creation.

Now i have a requirement to extract that month and year from this variable.

Also some filenames have different format like'PDFIPF......' instead of 'PDFST.....'.

so kindly suggest how to extract month and year from this variable.

Thank You.

Re: To Split a variable to get the date.

Former Member — Mon, 05 May 2008 10:13:39 GMT

hi use this

data: month(2) , year (4),

data: tmp type i, len type i.

len = strlen(file1).

tmp = len - 6.

month = file1+tmp(2).

tmp = tmp + 2.

year = file1+tmp(4).

reward if useful

Re: To Split a variable to get the date.

Former Member — Mon, 05 May 2008 10:14:22 GMT

Get strlen of the file and get the last 6 characters ..

I think month and year are stored at the last ...

v_len = strlen ( file1 ) .

v_len = v_len - 6.

v_date = file1+v_len.

Re: To Split a variable to get the date.

former_member784222 — Mon, 05 May 2008 10:18:43 GMT

Hi,

You can use fm STRING_REVERSE to reverse the name of the filename. Then go ahead and extact eight letters of the reversed string and once again reverse that, so at this you will get the date part in DDMMYYYY.

Again you can manipulate this date string to get back the original date.

1. use string_reverse input filename, output reversed string.

2. reversedstring+0(8) will extract date part ( reverse ).

3. Again reverse this string.

But seeing at the example, this would be tougher if the date in the filename is not in DDMMYYYY, meaning that if the date is 1st april 2008 then if the date format is DMYYYY(142008), then the logic would go for a toss.

Thanks and regards,

S. Chandramouli.

Re: To Split a variable to get the date.

Former Member — Mon, 05 May 2008 10:19:53 GMT

hi rohan,

u find the length of string , u have month an dyear at last only always, so u can easily cal the month , yr to diff strings

loop at itab into <string>.

x = strlen<string>.

y = x - 6.

z = x - 4.

month = string + y(2).

year = string + z(4).

clear string,x,y,z.

endloop.

reward if useful,

regards,

chandu.

Re: To Split a variable to get the date.

Former Member — Mon, 05 May 2008 10:22:01 GMT

Hi,

Try to use this code,

Thanks

Dharmishta

Re: To Split a variable to get the date.

Former Member — Mon, 05 May 2008 10:23:11 GMT

But also sometimes the variable conatins 'pdfst0000096286us16c1'.

In such cases i have to add current year to that.

Re: To Split a variable to get the date.

Former Member — Mon, 05 May 2008 10:58:22 GMT

hi after getting month and year in variables

do validation such as

you have month in month and yar in year variable.

use ISP_GET_MONTH_NAME FM to validate month

and VALIDATE_YEAR to validate year

if any one of fail use current month and year.

reward if useful.