Table wild cards

[Anonymous]

Hi guys,

I have a table with a list of customer info, here are some examples:

Bob Bates

Sid Roberts

James Jones

Bob Smith

Ed Jacobs

How can I analyze this table and make a graph showing how many of each forename we have in the table? The graph would show I have 2 bobs, 1 sid, 1 james and 1 ed

Thanks!

[Miguel_Angel_Baeyens]

Hi,

Using

SubField(CustomerName, ' ', 1)

will return this first name. You can store this into a new field and use later on on a chart.

Hope that helps.

Miguel

[Anonymous]

Where does that go? Graph or code?

[#4 · Accepted solution]

Hi,

By using Subfield function,

     SubField(Cust,' ',1) as FirstName

see the attach qvw.

Regards

Yigal

[Miguel_Angel_Baeyens]

Hi,

If possible, always in the script, in the LOAD part, creating a new field.

Hope that helps.

Miguel

[Anonymous]

Thanks guys