Skip to Content

Hi All,

 

OBJECTIVE:

 

You would have exported a database table’s content from CDB table/monitoring table/Cluster table. After exporting it as an excel file, the data comes into ‘ ‘ format which does not look good. Here is a procedure to refine that content.

 

REQUIREMENT:

 

  • SUP 2.x

 

Procedure:

 

You would have checked

 

How to access SUP CDB (Cache Database) ?

 

How to access SUP Monitoring DB?

 

The specified item was not found.

 

 

after executing a table query like select * from table_name,  you want to export that table’s content. All you need to do is:

 

1. go to Data  menu, click on Export

 

1.PNG

2. by default, your file would be saved as delimited text file. (go with default), click on Next

 

1.PNG

 

 

3. give some file name.

 

NOTE: if you don’t select any location, by default it will be placed at  C:\Sybase\UnwiredPlatform\Servers\SQLAnywhere12\BIN32

 

here, i am storing this file (test.csv) at my desktop.

 

check Include column names box.

 

NOTE : pass file name with extension .csv

1.PNG

 

4. Open an empty excel sheet,

go to Data  menu > From Text

 

1.PNG

 

 

5. Locate the text,csv,

 

go through below steps:

 

1.PNG

7. select Comma  from Delimiters, and from Text qualifier select ,

1.PNG

 

8. Once you finish it, a window will pop up like below. click on OK. you will get desired output.

 

 

1.PNG

 

 

 

Regards,

Jitendra

To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply