Hi,
I have a DB2 table imported to Excel which has some junk characters in some of its columns. This is a huge file and I need to identify which are the junk characters exist in this file. Is there a way to find this in excel or by using any other tool?
Thanks,
Vaishali
Hello vaishalis,
Yes there is, if you know what "junk characters" are, and explicitly reference all of it.I need to identify which are the junk characters exist in this file. Is there a way to find this..
Please consider:
Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .
in this case, I do not know what junk characters could be there. I just need to find out if there are any occurances apart from special characters.
You have to tell us the characters you consider junk, for instance these ردی حروف are "junk characters" to those who don't use Urdu.
@ Marcol,
I second that. Have a Bells and tap faster!
Lol!!!!!
@ XOR LX,
Don't you just come here and LOL!!!!
Marcol first has to up the tune a little as well!
@ Marcol,
No offence, of course.
I think you're being too harsh on him, Winon - surely Marcol's a single malt man!!
@ XOR LX,
Yip, might be, yet I believe he is a great guy and a valuable added asset to EF!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks