join CSPRODB

Discussions about tools to complement CSPro data processing
leulae
Posts: 39
Joined: December 16th, 2016, 5:51 am

join CSPRODB

Postby leulae » January 13th, 2018, 3:17 am

Hello all,

How do I join two CSPRODB file to One CSPRODB file. Then after I need to sort using CSSORT

Please help me on this regard

Thank in advance

Leulae

sah
Posts: 95
Joined: May 28th, 2015, 3:16 pm

Re: join CSPRODB

Postby sah » January 15th, 2018, 7:27 am

Go to tools then concatenate the files if and only if they are of same dictionary.

leulae
Posts: 39
Joined: December 16th, 2016, 5:51 am

Re: join CSPRODB

Postby leulae » January 16th, 2018, 12:25 pm

Thank sah, appreciate,

I know how to make one data file using different dictionaries with text data, sort tool help to sort Record sort. Finally we can get one data file

I need to join two CSPRODB files which belong to two different dictionaries and make one data file.

I can write batch file to do this, but finding convenient and easy way to do this

Thanks again

Leulae

Gregory Martin
Posts: 1104
Joined: December 5th, 2011, 11:27 pm
Location: Washington, DC

Re: join CSPRODB

Postby Gregory Martin » January 17th, 2018, 6:33 am

You can't directly do with the CSPro DB format. You will have to:

1) Convert the CSPro DB files to text files. You can use the Data Viewer to do this or do it with a batch application.

2) Do the manipulation with the text files (concat, record sort, etc.).

3) Convert from text back to CSPro DB (if needed).

The CSPro DB format is very convenient to use for data collection, but it has some limitations, which you've discovered with your task.

leulae
Posts: 39
Joined: December 16th, 2016, 5:51 am

Re: join CSPRODB

Postby leulae » January 19th, 2018, 9:31 pm

Thank you very much,

Leulae

Gregory Martin wrote:You can't directly do with the CSPro DB format. You will have to:

1) Convert the CSPro DB files to text files. You can use the Data Viewer to do this or do it with a batch application.

2) Do the manipulation with the text files (concat, record sort, etc.).

3) Convert from text back to CSPro DB (if needed).

The CSPro DB format is very convenient to use for data collection, but it has some limitations, which you've discovered with your task.


Return to “Tools”