Text file to Excel format
 

I have generated a report from the back end (oracle) which is in a text
format. like below(it actually comes in one line). But when i export to excel
format, I am getting the contents in different lines instead of one single
cell(the heading:activity log) due to which i am not able to user auto filter
in the ticket_number field. There will be more than 100 tickets, but when i
put filter it shows just the first ticket. Please help me out with this
issue.





Ticket_Number Activity_Log
-------------
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
162892 Actions Taken:
Have contacted the Development Team and they had said that it
will not consider languages other than English. When this reply was sent to
Jignesh, he said that it was not the case in other tickets(eg:
162348).


Next Actions:
I have contacted Murali again about the issue. He is currently
working on it.


Signatu
Swetha R S
Initial Ticket Status: Assigned To
Status after Modification: Work In Progress

Text file to Excel format
 

The best solution would be to save this as a text file itself and then use a
macro to separate the contents using the belong keywords. (If you are
familiar with macros)

Actions Taken:
Next Actions:
Signatu
Initial Ticket Status:
Assigned To
Status after Modification:

If this post helps click Yes
---------------
Jacob Skaria


"thalapathy" wrote:

I have generated a report from the back end (oracle) which is in a text
format. like below(it actually comes in one line). But when i export to excel
format, I am getting the contents in different lines instead of one single
cell(the heading:activity log) due to which i am not able to user auto filter
in the ticket_number field. There will be more than 100 tickets, but when i
put filter it shows just the first ticket. Please help me out with this
issue.





Ticket_Number Activity_Log
-------------
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
162892 Actions Taken:
Have contacted the Development Team and they had said that it
will not consider languages other than English. When this reply was sent to
Jignesh, he said that it was not the case in other tickets(eg:
162348).


Next Actions:
I have contacted Murali again about the issue. He is currently
working on it.


Signatu
Swetha R S
Initial Ticket Status: Assigned To
Status after Modification: Work In Progress

Text file to Excel format
 

Hi Jacob,

Thank you for your reply. can u please help me out with this macros. I have
not done this before.



"Jacob Skaria" wrote:

The best solution would be to save this as a text file itself and then use a
macro to separate the contents using the belong keywords. (If you are
familiar with macros)

Actions Taken:
Next Actions:
Signatu
Initial Ticket Status:
Assigned To
Status after Modification:

If this post helps click Yes
---------------
Jacob Skaria


"thalapathy" wrote:

I have generated a report from the back end (oracle) which is in a text
format. like below(it actually comes in one line). But when i export to excel
format, I am getting the contents in different lines instead of one single
cell(the heading:activity log) due to which i am not able to user auto filter
in the ticket_number field. There will be more than 100 tickets, but when i
put filter it shows just the first ticket. Please help me out with this
issue.





Ticket_Number Activity_Log
-------------
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
162892 Actions Taken:
Have contacted the Development Team and they had said that it
will not consider languages other than English. When this reply was sent to
Jignesh, he said that it was not the case in other tickets(eg:
162348).


Next Actions:
I have contacted Murali again about the issue. He is currently
working on it.


Signatu
Swetha R S
Initial Ticket Status: Assigned To
Status after Modification: Work In Progress

Text file to Excel format
 

Would require a sample text file and the fields you need to extract to do
this..Do you have some other options in the export window like export as a
..csv ..

If this post helps click Yes
---------------
Jacob Skaria


"thalapathy" wrote:

Hi Jacob,

Thank you for your reply. can u please help me out with this macros. I have
not done this before.



"Jacob Skaria" wrote:

The best solution would be to save this as a text file itself and then use a
macro to separate the contents using the belong keywords. (If you are
familiar with macros)

Actions Taken:
Next Actions:
Signatu
Initial Ticket Status:
Assigned To
Status after Modification:

If this post helps click Yes
---------------
Jacob Skaria


"thalapathy" wrote:

I have generated a report from the back end (oracle) which is in a text
format. like below(it actually comes in one line). But when i export to excel
format, I am getting the contents in different lines instead of one single
cell(the heading:activity log) due to which i am not able to user auto filter
in the ticket_number field. There will be more than 100 tickets, but when i
put filter it shows just the first ticket. Please help me out with this
issue.





Ticket_Number Activity_Log
-------------
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
162892 Actions Taken:
Have contacted the Development Team and they had said that it
will not consider languages other than English. When this reply was sent to
Jignesh, he said that it was not the case in other tickets(eg:
162348).


Next Actions:
I have contacted Murali again about the issue. He is currently
working on it.


Signatu
Swetha R S
Initial Ticket Status: Assigned To
Status after Modification: Work In Progress

Text file to Excel format
 

How can i attach a text file in this discussion group. and i can take the
report in .csv file. but all the columns in the report comes in one column (A)

"Jacob Skaria" wrote:

Would require a sample text file and the fields you need to extract to do
this..Do you have some other options in the export window like export as a
.csv ..

If this post helps click Yes
---------------
Jacob Skaria


"thalapathy" wrote:

Hi Jacob,

Thank you for your reply. can u please help me out with this macros. I have
not done this before.



"Jacob Skaria" wrote:

The best solution would be to save this as a text file itself and then use a
macro to separate the contents using the belong keywords. (If you are
familiar with macros)

Actions Taken:
Next Actions:
Signatu
Initial Ticket Status:
Assigned To
Status after Modification:

If this post helps click Yes
---------------
Jacob Skaria


"thalapathy" wrote:

I have generated a report from the back end (oracle) which is in a text
format. like below(it actually comes in one line). But when i export to excel
format, I am getting the contents in different lines instead of one single
cell(the heading:activity log) due to which i am not able to user auto filter
in the ticket_number field. There will be more than 100 tickets, but when i
put filter it shows just the first ticket. Please help me out with this
issue.





Ticket_Number Activity_Log
-------------
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
162892 Actions Taken:
Have contacted the Development Team and they had said that it
will not consider languages other than English. When this reply was sent to
Jignesh, he said that it was not the case in other tickets(eg:
162348).


Next Actions:
I have contacted Murali again about the issue. He is currently
working on it.


Signatu
Swetha R S
Initial Ticket Status: Assigned To
Status after Modification: Work In Progress