topic Re: application server file path name separated by apace in Application Development and Automation Discussions

application server file path name separated by apace

Bharath84 — Thu, 21 Aug 2014 07:45:33 GMT

Hi All,

I am writing files on application server. Below is my fie path.

parameters: p_o_file like rlgrap-filename default '/xxx/tmp/app/outbound/1~lcxxxx~ACTUAL~periodfyyear~RR.txt'.

data : mnthyear(12) type c,

year(6) type c.

case p_rpmax.

when '010'.

p_ryear = p_ryear - 1.

concatenate 'FY' p_ryear into year.

concatenate 'OCT' '-' year into mnthyear separated by space.

replace 'periodfyyear' with mnthyear into p_o_file.

In the report output I am getting the file name correctly.

Output File: /dev/tmp/app/outbound/1~LC1000~ACTUAL~OCT - FY2013~RR.txt

When checked in AL11, it is showing me the below file name

1~LC1000~ACTUAL~OCT

my file name is truncated after space.

Can we create a file name with spaces? Awaiting your replies.

Thanks,

Haritha

Re: application server file path name separated by apace

former_member201275 — Thu, 21 Aug 2014 08:12:28 GMT

No, on AL11 a filename cannot have a space.

Re: application server file path name separated by apace

Former Member — Thu, 21 Aug 2014 10:14:41 GMT

Hi,

I could create file on the application server with the name which you have specified... I have Windows NT

Re: application server file path name separated by apace

Bharath84 — Thu, 21 Aug 2014 10:33:21 GMT

Hi Abhijit,

Can you please explain how you have done this. It will be helpful if you can share the code.

Thanks,

Re: application server file path name separated by apace

Former Member — Thu, 21 Aug 2014 11:33:53 GMT

Pl find snipet..

FORM save_file.
   DATA: lv_data TYPE string.

*Move complete path to filename
   gv_file = '1~LC1000~ACTUAL~OCT - FY2013~RR.txt'.

* Open the file in output mode
   OPEN DATASET gv_file FOR OUTPUT IN TEXT MODE ENCODING DEFAULT.
   IF sy-subrc NE 0.
     MESSAGE 'Unable to create file' TYPE 'I'.
     EXIT.
   ENDIF.

   LOOP AT gt_spfli INTO gwa_spfli.
     CONCATENATE gwa_spfli-carrid
                 gwa_spfli-connid
                 gwa_spfli-countryfr
                 gwa_spfli-cityfrom
                 gwa_spfli-airpfrom
                 gwa_spfli-countryto
                 gwa_spfli-cityto
                 gwa_spfli-airpto
                 gwa_spfli-arrtime
      INTO lv_data
      SEPARATED BY ','.
*TRANSFER moves the above fields from workarea to file with comma
*delimited format
     TRANSFER lv_data TO gv_file.
     CLEAR: gwa_spfli.
   ENDLOOP.
* close the file
   CLOSE DATASET gv_file.

ENDFORM.

Re: application server file path name separated by apace

Bharath84 — Thu, 21 Aug 2014 12:43:14 GMT

Hi Abhijit,

The file path on the selection will be in disable mode and the file name was declared as a default value.

I am having p_bukrs, p_year, p_monat on the selection scree.

For co.code lc1000, fy2014, P10, the file should be 1~LC1000~ACTUAL~OCT - FY2013~RR.txt

For co.code lc2000, fy2014, P11, the file should be 1~LC2000~ACTUAL~NOV - FY2013~RR.txt

For co.code lc1000, fy2014, P05, the file should be 1~LC1000~ACTUAL~MAY - FY2014~RR.txt

The file name should be dynamic based on the input. I am able to get the file name without spaces on appl.server. If there are spaces in file name in appl server, it is truncating after the space.

Can we write dynamic file name separated by spaces in appl server?

Awaiting replies.

Thanks,

Re: application server file path name separated by apace

Former Member — Thu, 21 Aug 2014 13:03:15 GMT

I used you code and build the file and it updates it as well...

data : mnthyear(12) type c,
p_ryear(4) type c value '2014',
year(6) type c.

p_ryear = p_ryear - 1.

concatenate 'FY' p_ryear into year.

concatenate 'OCT' '-' year into mnthyear separated by space.

I replaced OCT with NOV just to check if the file gets created..

gv_file = p_o_file.

* Open the file in output mode
OPEN DATASET gv_file FOR OUTPUT IN TEXT MODE ENCODING DEFAULT.

What is your operating system, it could be the restriction of the same.

Re: application server file path name separated by apace

Bharath84 — Thu, 21 Aug 2014 13:40:15 GMT

I am using Win 7 and in 4.0B system. There is no keyword ENCODING DEFAULT in 4.0B.

Re: application server file path name separated by apace

Former Member — Fri, 22 Aug 2014 04:42:05 GMT

Can you check what is the syntax of OPEN DATA in your version? I am not sure if that really impacts the file name...

Re: application server file path name separated by apace

Bharath84 — Fri, 22 Aug 2014 05:47:54 GMT

Hi,

Below is the syntax:

OPEN DATASET p_o_file FOR OUTPUT IN TEXT MODE.

There is no addition ENCODING DEFAULT in 4.0B.

parameters: p_o_file like rlgrap-filename default '/xxx/tmp/app/outbound/1~lcxxxx~ACTUAL~periodyr~RR.txt'.

data : monthyr(12) type c.

constants : c_space(1) type c value ' '.

case p_rpmax.

when '001'.

p_ryear = p_ryear - 1.

concatenate 'JAN' c_space '-' c_space 'FY' p_ryear into monthyr.

replace periodyr with monthyr into p_o_file.

when '002'.

p_ryear = p_ryear - 1.

concatenate 'FEB' c_space '-' c_space 'FY' p_ryear into monthyr.

replace periodyr with monthyr into p_o_file.

when '003'.

p_ryear = p_ryear - 1.

concatenate 'MAR' c_space '-' c_space 'FY' p_ryear into monthyr.

replace periodyr with monthyr into p_o_file.

endcase.

In AL11 it is giving me the below file name.

1~LC1000~ACTUAL~JAN

It is truncating after the spaces.

Re: application server file path name separated by apace

Former Member — Fri, 22 Aug 2014 11:21:28 GMT

My version doesn't allow OPEN DATASET without IN TEXT MODE so I am not able to test anything...

Can you check if you can save a file with name larger than what it is saving now.. just forget abt spaces, check if the system is restricting you to that size.

Will CONDENSE command work for you?

Regards

Re: application server file path name separated by apace

Bharath84 — Fri, 22 Aug 2014 12:41:53 GMT

There are many files in my appl. server with files with file name having larger than what I said.

Re: application server file path name separated by apace

Former Member — Fri, 22 Aug 2014 13:34:56 GMT

Any luck with CONDENSE stmt?

Re: application server file path name separated by apace

Bharath84 — Fri, 22 Aug 2014 13:41:15 GMT

Can you tell me where exactly I have to use the CONDENSE keyword?

Re: application server file path name separated by apace

Former Member — Fri, 22 Aug 2014 14:13:15 GMT

CONDENSE p_o_file.

before open dataset

Re: application server file path name separated by apace

SimoneMilesi — Fri, 22 Aug 2014 14:55:35 GMT

better add

CONDENSE p_o_file NO-GAPS.

Re: application server file path name separated by apace

Bharath84 — Mon, 25 Aug 2014 06:03:03 GMT

I used CONDENSE p_o_file NO-GAPS. I am getting the below file name :

1~LC1000~ACTUAL~OCT-FY2013~RR.txt

But I need a single space before and after the "hyphen" symbol as below:

1~LC1000~ACTUAL~OCT - FY2013~RR.txt

Re: application server file path name separated by apace

VenkatRamesh_V — Mon, 25 Aug 2014 06:17:26 GMT

Hi Haritha,

Hope it helpful.

data: lv_data TYPE string,
       lv_text1 TYPE string,
       lv_text2 TYPE string,
       lv_text3 TYPE string.

START-OF-SELECTION.

lv_data = '1~LC1000~ACTUAL~OCT-FY2013~RR.txt'.

SPLIT lv_data at '-' INTO lv_text1 lv_text2.

CONCATENATE lv_text1 '-' lv_text2 INTO lv_text3 SEPARATED BY space.

WRITE lv_text3.

Regards,

Venkat.

Re: application server file path name separated by apace

Former Member — Mon, 25 Aug 2014 07:40:10 GMT

Hi Haritha,

As you are saying you want a spaces before and after the '-' so your file name will be now

/xxx/tmp/app/outbound/1~lcxxxx~ACTUAL~JAN - FY2013~RR.txt

If this correct can you try this ..

data: file1(50) type c value '/xxx/tmp/app/outbound/1~lcxxxx~ACTUAL~',
file2(10) type c value '~RR.txt'.

concatenate 'JAN' '-' 'FY' into mnthyear separated by space.
concatenate mnthyear p_ryear into mnthyear.
concatenate file1 mnthyear file2 into p_o_file.

I have done for January.

Let me know if it is working..

Regards

Re: application server file path name separated by apace

Bharath84 — Mon, 25 Aug 2014 10:56:40 GMT

data : monthyr(8) type c,

periodyr(12) type c,

case p_rpmax.

when '010'.

p_ryear = p_ryear - 1.

concatenate 'OCT' '-' 'FY' into monthyr separated by space.

concatenate monthyr p_ryear into periodyr.

Below is the filename in AL11. It is truncating after OCT