Converting Pipe Delimiter Data into Excel for Reading

Steps :

1. Samplepipedelimiter.txt

    FirstName|LastName|Email|SamAccount|EmployeeNumber

    Prasad|Beedangari|oracleidm06@gmail.com|reddypx6|123456

2. Open Excel sheet and click on first cell and paste the data of samplepipedelimiter.txt

3. Naviagate Data in Exel ----> Text to columns ----> Delimited Click on next

4. Delimiters

   

    check Tab and other as | (pipe delimiter)

5.  click on finish