Scan malfunction

Greek — Wed, 14 May 2014 18:35:50 GMT

Good afternoon,

I am trying to scan a few words and I am having troubles with the scan function. I am having the following data set and I would like to create a new variable with the country name.

Sal_Plan_Descr

Angola Salary Structure

Armenia Salary Structure

Benin Salary Structure

Burkina Faso Salary Structure

I would like to get

Country	Sal_Plan_Descr
Angola	Angola Salary Structure
Armenia	Armenia Salary Structure
Benin	Benin Salary Structure
Burkina Faso	Burkina Faso Salary Structure

Since Burkina Faso has two words, I used the following scan function: Country=scan(Sal_Plan_Descr, 1, 'Salary'); so that I get the entire name of the country. However, I get this:

Country	Sal_Plan_Descr
Angola	Angola Salary Structure
A	Armenia Salary Structure
B	Benin Salary Structure
B	Burkina Faso Salary Structure

Do you know why the scan function does not cooperate?

Thanks!

Re: Scan malfunction

PGStats — Wed, 14 May 2014 18:49:59 GMT

The third argument to the SCAN function is a list of characters that may separate words. It is not a word to search for.

Try

Country= substr(Sal_Plan_Descr, 1, findw(Sal_Plan_Descr, 'Salary') - 1);

instead.

Re: Scan malfunction

Greek — Thu, 15 May 2014 17:40:39 GMT

It worked!

Thank you

Re: Scan malfunction

Ksharp — Fri, 16 May 2014 14:23:20 GMT

tranwrd(x,'Salary Structure','');

topic Re: Scan malfunction in ODS and Base Reporting

Scan malfunction

Re: Scan malfunction

Re: Scan malfunction

Re: Scan malfunction