replacing an empty value in the datastage
Moderators: chulett, rschirm, roy
-
- Charter Member
- Posts: 822
- Joined: Sat Sep 17, 2005 5:25 pm
- Location: USA
-
- Premium Member
- Posts: 315
- Joined: Tue Oct 31, 2006 3:38 pm
-
- Premium Member
- Posts: 315
- Joined: Tue Oct 31, 2006 3:38 pm
Not sure of Ultraedit, but with XVI32 you can do the below.
As Craig said let us know the corresponding value.
Guess...
In your file do you have these small squares occurring in pairs, they could be '0D 0A' (carriage returns)
Open the file in a XVI32, you can see the HEX value of all the characters.
Do a "Replace All" of "0D 0A" with a space (Or whatever you want it to be)
As Craig said let us know the corresponding value.
Guess...
In your file do you have these small squares occurring in pairs, they could be '0D 0A' (carriage returns)
Open the file in a XVI32, you can see the HEX value of all the characters.
Do a "Replace All" of "0D 0A" with a space (Or whatever you want it to be)
Narasimha Kade
Finding answers is simple, all you need to do is come up with the correct questions.
Finding answers is simple, all you need to do is come up with the correct questions.
-
- Premium Member
- Posts: 315
- Joined: Tue Oct 31, 2006 3:38 pm
-
- Premium Member
- Posts: 315
- Joined: Tue Oct 31, 2006 3:38 pm
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Sounds like you successfully replaced all the record terminators with spaces. Return to the original file.
What is the value of the record terminator property in the Sequential File stage? If it is UNIX style, try setting the final delimiter property to \r
What is the value of the record terminator property in the Sequential File stage? If it is UNIX style, try setting the final delimiter property to \r
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.
-
- Premium Member
- Posts: 315
- Joined: Tue Oct 31, 2006 3:38 pm
previoulsy i have used delimiter none, i think that is the reason data is comming in a single row. but now i changed to delimiter=end and i am getting the error
Field "WFAC_PASSWORD" with 'delim=end' did not consume entire input, at offset: 227
Personnel,0: Field "WFAC_PASSWORD" with 'delim=end' did not consume entire input, at offset: 307
Personnel,0: Field "WFAC_PASSWORD" with 'delim=end' did not consume entire input, at offset: 234
Personnel,0: Field "WFAC_PASSWORD" with 'delim=end' did not consume entire input, at offset: 313
Personnel,0: Import complete. 0 records imported successfully, 23395 rejected.
Sequential_File_15,0: Export complete. 0 records exported successfully, 0 rejected.
i have the problem with only this column. this is the last column of the file. it look everything is fine in the file. Can u please tell me the reason?
Field "WFAC_PASSWORD" with 'delim=end' did not consume entire input, at offset: 227
Personnel,0: Field "WFAC_PASSWORD" with 'delim=end' did not consume entire input, at offset: 307
Personnel,0: Field "WFAC_PASSWORD" with 'delim=end' did not consume entire input, at offset: 234
Personnel,0: Field "WFAC_PASSWORD" with 'delim=end' did not consume entire input, at offset: 313
Personnel,0: Import complete. 0 records imported successfully, 23395 rejected.
Sequential_File_15,0: Export complete. 0 records exported successfully, 0 rejected.
i have the problem with only this column. this is the last column of the file. it look everything is fine in the file. Can u please tell me the reason?
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: