Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Applcation Server File.

Former Member
0 Kudos

*Hi All ,*

*I am getting a file from Application Server with pipe separator.*

*BUt My issue is Data that is coming from Application Server is having doubles quotes which is having pipe Seperator in it.*

I want to consider the total field in double quotes as single field rather than two fields ignoring the pipe seperator in it.

My File looks like this.

USD|1.00|M|N|DINNER||"TOAST|KITCHEN & WINE BAR"|

I want to consider ||"TOAST|KITCHEN & WINE BAR"| as a single field instead of two fields ignoring pipe separator in it.

Thanks in Advance.

<< Please do not offer "rewards" >>

Edited by: Rob Burbank on May 26, 2010 2:43 PM

2 REPLIES 2

Former Member
0 Kudos

Hi,

try:

CONSTANTS: w_tab TYPE c VALUE %_horizontal_tab.

data: begin of i_text occurs 0,
        w_line(1000),
      end of i_text.

data: w_ct  type i,
      w_pos type i,
      w_len type i.

data: w_flag,
      w_field1(10),
      w_field2(10),
      w_field3(10),
      w_field4(10),
      w_field5(10),
      w_field6(10),
      w_field7(100),
      w_field8(10).

i_text-w_line = 'USD|1.00|M|N|DINNER||"TOAST|KITCHEN & WINE BAR"|'.
append i_text.

loop at i_text.

   w_len = strlen( i_text ).
   w_ct = 0.
   while w_ct < w_len.
       if w_flag is initial  and  i_text+w_ct(1) = '|'.
          i_text+w_ct(1) = w_tab.
       elseif i_text+w_ct(1) = '"'.
          if w_flag is initial.
             w_flag = 'X'.
          else.
             clear w_flag.
          endif.
       endif.
       w_ct = w_ct + 1.
   endwhile.

   split i_text at w_tab into w_field1 w_field2 w_field3
                              w_field4 w_field5 w_field6
                              w_field7 w_field8.
   write: / w_field1, w_field2, w_field3, w_field4, w_field5, w_field6,
            w_field7, w_field8.
endloop.

Best regards,

Leandro Mengue

0 Kudos

Hi ,

Thanks for your reply but in my file double quotes comes dynamically and it has to updated two database table.

Is there any way wa can replace the '|' separator between the double quotes in that string without splitting the string in that case.

Thanks ,

Naveen