DSXchange

Hi All,

I have the sequential file with the Values as

Kumar[NUL][NUL]
Bala[NUL][NUL]

In a single column, I need to remove the [NUL] values from it and lkp with reference data. your help will be highly appreciated.

By "[NUL]" do you mean those five characters, do you mean the ASCII NUL character (Char(0)), or do you mean something else (and, if so, what)?

When I open the file in Notepad++ one of the column show as

Kumar[NUL][NUL]
Bala[NUL][NUL]

It looks like ASCII characters, I tried filter option in sequential file

tr -c '\0\ '' But it didnt work

Forget anything like notepad, what does a UNIX hex editor show? Or a dump like "od -h" or whatever will give you a hex dump on your O/S.

Below convert function helped me to avoid the NUL values.

Convert(Convert(' ABCDEFGHIJKLMNOPQRSTUVWXZYabcdefghijklmnopqrstuvwxyz0123456789','', Trim(colname)),'', Trim(colname))

That convert function might "work", but it isn't what I would call a good solution, especially because of the performance impact.

What is the Best way to handle NUL from the Source?

Once you know what it really is, a simple Convert() function to remove it - to convert it to "" - will do the trick.
Imagine that it happens to be the ASCII NUL character (0x00).
Declare a stage variable svNUL of type Char(1) and initialize it to Char(0).
When tidying up your string in the job