i have customer name and customer code together
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.
For name try this
SubField(YourField,'-', 2) as Name
For Customer code try this
SubField(YourField,'-', 1) as CustomerCode
View solution in original post
Try with subfield(), like:
SubField(YourStringField,'-', 2) as Name
subfield(code_Name,'-',1) as code,
trim(subfield(code_Name,'-',2)) as Name
try like this
SubField(YourFieldName,'-',-1) as Name
thanks ashfaq it is working
Please close the thread by selecting appropriate answers.
Hi, you also can try:
Trim(Mid(YourField, Index(YourField, '-')+1))
this is getting me only character "a, - , z"