topic Re: Reg: after space remove data(record) in Application Development and Automation Discussions

Reg: after space remove data(record)

Former Member — Thu, 30 Oct 2008 23:04:29 GMT

Hi all,

I want to fatch one text code from t053 table. I have written query like below:

select single KURZT into recone-dicscode from t053

where SPRAS = 'E' and langt = line-sgtxt.

But here problem is t053 table has langt data like this u201CSYSTEMATIC WITHDRAWALu201D and line-sgtxt data has u201CSYSTEMATIC WITHDRAWAL 1200120000u201D so my query always fail( sy-subrc = 4), so I want to take only u201CSYSTEMATIC WITHDRAWALu201D form line-sgtxt.

How I cut data after space? Can you give me some idea?

Please help me.

Thanks

JIgar

Re: Reg: after space remove data(record)

Former Member — Thu, 30 Oct 2008 23:51:27 GMT

use SPLIT

Re: Reg: after space remove data(record)

Former Member — Fri, 31 Oct 2008 00:09:39 GMT

Hi MxG.

Thanks for reply..

can u give some more idea about spilt in this case..

Thanks

Jigar

Re: Reg: after space remove data(record)

Former Member — Fri, 31 Oct 2008 00:32:38 GMT

press F1 on split

Re: Reg: after space remove data(record)

Former Member — Fri, 31 Oct 2008 00:38:54 GMT

Hi MxG.

Thanks for reply.

I got it idea about split. i used also in my program, but in my case this is not working because i SGTXT so many space are coming so how i know in which part i have to split the statement.

any idea about Contains String CS ?

Thanks

Jigar

Re: Reg: after space remove data(record)

Former Member — Fri, 31 Oct 2008 00:41:28 GMT

Where you need to split? do you know if your SGTXT will have any pattern?

Re: Reg: after space remove data(record)

Former Member — Fri, 31 Oct 2008 00:50:24 GMT

Hi MxG.

Yes i know see like below:

1) SYSTEMATIC WITHDRAWAL

2) SYSTEMATIC WITHDRAWAL TAX

3) 111300958 /WIRE/OUT-200822400122;BNF VALIC;REF

4) 111300958 /RETURN ITEM

5) MINIMUM DISTRIBUTION

so split is not posible for me.. i think MxG i have to find the sting match for my T053-KURZT string.... i Couldnu2019t get any idea.

Thanks

Jigar

Re: Reg: after space remove data(record)

Former Member — Fri, 31 Oct 2008 01:00:23 GMT

Hi Jigar,

According to your query "SYSTEMATIC WITHDRAWAL 1200120000"

has to be printed as SYSTEMATIC WITHDRAWAL, so code a logic such that you will always read characters ignoreing numerical s so that your issue will be resolved if numericals are present in the middle of the characters means we have to think for another logic.

If i am wrong correct me.

Cheers!!

VEnk@

Re: Reg: after space remove data(record)

Former Member — Fri, 31 Oct 2008 01:04:34 GMT

Hi Venkat,

there is a not fix first is a characters and after numerical. anything is coming from database...

any other idea...

Thanks

Jigar

Re: Reg: after space remove data(record)

Former Member — Fri, 31 Oct 2008 01:05:00 GMT

ok, and what will be the extra text after these Actual texts? woudl that always be numeric? or woudl that will have fixed length?

Re: Reg: after space remove data(record)

Former Member — Fri, 31 Oct 2008 01:12:34 GMT

Hi MxG,

There is a not fix about extra space..... after Actual texts.

some time numeric also and some time char also.. there is a not fix length.....

Thanks

Jigar

Re: Reg: after space remove data(record)

Former Member — Fri, 31 Oct 2008 01:14:20 GMT

would the last part of the string which you want to cut off atleast a single word? or can it be multiple words ?

Re: Reg: after space remove data(record)

Former Member — Fri, 31 Oct 2008 01:16:11 GMT

it can be multiple words.......

Re: Reg: after space remove data(record)

Former Member — Fri, 31 Oct 2008 01:20:33 GMT

how would you find even manually on what you need to pick it up from that string? just by looking and on knowledge on what is the value you need to pick?

there has to be some pattern in order for you to program this code, else you cant do that. you can search based on some fixed length ( say 20 bytes ), and then using like% in the where clause but that wouldnt work for all the cases

Re: Reg: after space remove data(record)

Former Member — Tue, 21 Dec 2010 04:58:38 GMT

Thanks