Page 2 of 2

Posted: Mon Jan 30, 2012 3:03 pm
by kiran.vits
Hi dichandr,

If i am correct, Your sample data itself is like delimite by "#".

1. Mail the PS file as .txt.
2. while opening the .txt file using Excel , Text Import wizard will be displayed.. In this select the "Delimited" radio button and in next page select the Delimiter as "#" and then press finish.
3. Your data will be splitted into coloumns which are seperated by "#"

Hope this will serve u the solution. :)

Posted: Sat Apr 07, 2012 1:06 pm
by NicC
amna567 wrote:Estimates are that about 75 percent of all business data worldwide still resides on mainframes and 85 percent of all business transactions are carried out on mainframes.
The mainframe world is driven by increased usage of digital services that constitute more and more of the world economy. These services are more often than not run by mainframes in a central data center setting. These demands are subject to the fluctuations of web-driven demand and therefore need the strengths that only the mainframe can deliver: reliability, availability and scalability all wrapped in the most secure computing environment.
And this has what relevance to the topic??

Posted: Sat Apr 07, 2012 2:50 pm
by amna567
Yeah i decided to wrote about Mainframes first :)
i think while opening the .txt file using Excel , Text Import wizard will be displayed.. In this select the "Delimited" radio button and then #
your work related to excel mail donr :)

Posted: Mon Jun 18, 2012 4:05 pm
by cmsmoon
you can use Delmited separtor as comma(,) .the you can extract PDS and it extracted file extension should be .csv.
Now you can get directly excel format