topic Re: Removing Null values from character string in Application Development and Automation Discussions

Removing Null values from character string

Former Member — Fri, 22 Jun 2007 11:57:49 GMT

Hi All,

Can i remove NULL values (hexadecimal - 0000) from character string. I am uploading a file from presentation layer (shared server) and getting NULL values in many fields which i want to remove.

please assist.

Thanks for you help..

Regards,

Mohaiyuddin

Re: Removing Null values from character string

Former Member — Fri, 22 Jun 2007 13:20:15 GMT

Hi Mohaiyuddin

What is the type of file that you are uploading?

What is the function module that you are using to upload the file?

Re: Removing Null values from character string

RichHeilman — Fri, 22 Jun 2007 13:21:21 GMT

Simply move space to them.

field1 = space.

Regards,

RIch Heilman

Re: Removing Null values from character string

Former Member — Mon, 25 Jun 2007 06:39:23 GMT

I am uploading text file with ASC format using FM GUI_UPLOAD

Re: Removing Null values from character string

Former Member — Mon, 25 Jun 2007 06:40:50 GMT

Just assign space to the field as told by Rich.

Or just use CONDENSE.

Reward points if useful.

Regards,

Atish

Re: Removing Null values from character string

Former Member — Mon, 25 Jun 2007 06:42:07 GMT

Null values are embedded in field -- example field value = L## (I have used replacement = #, its not working, it's showing # while debugging, but downloading it as NULL, L## -- 004C 000D 0000 -- hex for L, hex for CR and hex for NULL). i want to remove null from this value.

Re: Removing Null values from character string

Former Member — Mon, 25 Jun 2007 06:45:19 GMT

Hi Atish,

I tried condense, split, replace...none is working properly. i cannot declare char variable with NULL value. I have to declare it in X format....String manipulation does not work with X and character combined with each other. (i tried declaring hex variable -- assigning it null and then moving the value to char, it is not working as well)

Re: Removing Null values from character string

Former Member — Fri, 04 Jul 2008 12:20:04 GMT

no solution found.. Implemented work around at file source.

Re: Removing Null values from character string

Former Member — Thu, 02 Apr 2015 03:54:28 GMT

Hi,

Most likely, nobody needed it, but if anybody in future will need the solution for related problem - here's solution:

data: lv_nullchar type xstring value '0'.

shift lv_xstring right deleting trailing lv_nullchar in byte mode.

shift lv_xstring left deleting leading lv_nullchar in byte mode.

This hack deleting null chars in lv_xstring at end file and at begining of file. Works perfect for me, where i also worked with files.

Re: Removing Null values from character string

gzontini — Thu, 22 Sep 2022 15:00:21 GMT

This works perfectly for us, your're the best Former Member I've ever met.

Thanks!