NUL Values
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 86
- Joined: Mon Nov 27, 2006 3:42 am
- Location: Wilmington
NUL Values
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.
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.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 86
- Joined: Mon Nov 27, 2006 3:42 am
- Location: Wilmington
-
- Participant
- Posts: 86
- Joined: Mon Nov 27, 2006 3:42 am
- Location: Wilmington
-
- Participant
- Posts: 86
- Joined: Mon Nov 27, 2006 3:42 am
- Location: Wilmington
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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
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
Code: Select all
Convert(svNUL, "", InLink.TheString)
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.