topic Re: CSV Format Download? in Application Development and Automation Discussions

CSV Format Download?

Former Member — Thu, 07 Jun 2007 22:16:35 GMT

Hi Guys,

I got error while downloading the data into a text file in CSV or Comma seperated values format .

The error says that "Only Character type data objects are supported at the argument Position OP1 for the statement

"IF......op1 CO op2 ...."

In this case ,the operand "op1" has non-character type "I".The current program is flagged as a Unicode Program.In the Unicode context , type X fieldsare seen as Non-character type , as are structures tha contain non-charatcer-type

components"

can anybody tell me how to correct this one.

Thanks,

Gopi.

Re: CSV Format Download?

Former Member — Thu, 07 Jun 2007 22:31:20 GMT

Hi Gopi,

You need to define the field op1 as character. If you can't do that then define a local variable l_op1 as char and then move op1 to l_op1 and use l_op1 in your IF statement. What about your yesterday's issue?

Reward points if useful.

Regards,

Atish

Re: CSV Format Download?

Former Member — Thu, 07 Jun 2007 22:59:05 GMT

Hi Atish,

Thanks for ur repsonse.I didnot get u exactly.What i am doing is downloading BSAK Table in to text file all columns using comma as a seperator .

Now how can i know which filed and how to convert .

Thanks,

Gopi.

Re: CSV Format Download?

Former Member — Thu, 07 Jun 2007 23:04:54 GMT

Hi Gopi,

BSAK has lots of fields which are not character, while downloading them you have to assign them to a local variable of character type and then do your string operation.

Revert back if still not clear.

And please close your old threads by rewarding points as it really encourage.

Regards,

Atish

Message was edited by:

Atish Sarda

Re: CSV Format Download?

Former Member — Thu, 07 Jun 2007 23:13:39 GMT

Hi Atish,

I debugged the program.I got the error at 155th column i think exactly or 156 may be.so u mean now i have to declare a Internal Table with character as a type for all the fileds in BSAK r what?and if so next u mean i have to do string operation can u tell me how to do string operation?

Thanks,

Gopi.

Re: CSV Format Download?

Former Member — Thu, 07 Jun 2007 23:18:28 GMT

Hi Gopi,

How are you downloading the data?

What Atish meant was that you should declare the internal table with character type fields.

Then you will not encounter any problem downloading it.

But if you want to download the table data from BSAK , why not use se16 itself?

YOu can first dowload it to EXcel and then you can convert it to csv.

Regards,

Ravi

Re: CSV Format Download?

Former Member — Thu, 07 Jun 2007 23:34:38 GMT

Hi ravi,

But u can't get all the fields thru se16 i mean all the columns.

Coming to what Atish told is to" declare the in ternal table with with character type fields" mean i have to declare all the fields of the BSAK with character type or what?

Thanks,

Gopi.

Re: CSV Format Download?

Former Member — Thu, 07 Jun 2007 23:44:14 GMT

Hi Gopi,

I'm afraid you have to do it ...I know its very difficult but thats is the wayy it is.

Are you using GUI_DOWNLOAD for this?

Regards,

Ravi