Expression Help

[abhaysingh]

i have customer name and customer code together

ex-

D300098-Abhay Singh

E100094-B.Ahlawat

w9995ii - xyz

i want the names only from them.

i have tried Left and Right function but not getting proper result.

can any one help me in that.

regards

abhay

[tresesco]

Try with subfield(), like:

Load

SubField(YourStringField,'-', 2) as Name

[#3]

Hi,

Try this

Table:

Load code_Name,

         subfield(code_Name,'-',1) as code,

         trim(subfield(code_Name,'-',2)) as Name

From Table;

[#4]

try like this

keepchar(yoursting,'a-z')

[ashfaq_haseeb · Accepted solution]

Hi,

For name  try this

SubField(YourField,'-', 2) as Name

For Customer code try this

SubField(YourField,'-', 1) as CustomerCode

Regards

ASHFAQ

[MK_QSL]

SubField(YourFieldName,'-',-1) as Name

[abhaysingh]

thanks ashfaq it is working

[ashfaq_haseeb]

Please close the thread by selecting appropriate answers.

Regards

ASHFAQ

[rubenmarin]

Hi, you also can try:

Trim(Mid(YourField, Index(YourField, '-')+1))

[abhaysingh]

this is getting me only character "a, - , z"