Hi, I have an excel file that need to be converted to a pipe (|) delimited plain text file. Excel offers saving in tab,space and comma delimted form, but not any other characters. PLEASE help to let me know how to do this!
Thanks for the suggestion. I tried this method. The problem with comma or space is you might have comma or space as part of a field data, so you might add extra pipe there, using tab as delimiter, the search and replace function in Notepad does not let you to search by tab. So that doesn't work neither. Can you somehow trick the search to take tab as input? Thanks.