Amour22015
asked on
Crystal Reports 2008 - First position in field is " "
Hi and thanks,
I have this code:
If {TEMP_PWC_Sales_Report_SP_ MAIN.Owner Address} > "" Then
Left({TEMP_PWC_Sales_Repor t_SP_MAIN. OwnerAddre ss}, Instr({TEMP_PWC_Sales_Repo rt_SP_MAIN .OwnerAddr ess}, " ") -1)
Else "";
This works fine until there is a bland in the first position of the field Example:
|1234 Church Street| <== this works fine and gives me |1234|
| 1234 Church Street| <=== This give me a return that is blank
Also:
I would like to find the formula for:
|1234 Church Street| = |Church Street|
Thanks
I have this code:
If {TEMP_PWC_Sales_Report_SP_
Left({TEMP_PWC_Sales_Repor
Else "";
This works fine until there is a bland in the first position of the field Example:
|1234 Church Street| <== this works fine and gives me |1234|
| 1234 Church Street| <=== This give me a return that is blank
Also:
I would like to find the formula for:
|1234 Church Street| = |Church Street|
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Does the text always have the | | around it or did you add those for clarity?
mlmcc
mlmcc
ASKER
mlmcc,
added || for clarity
added || for clarity
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks for all your help...
If {TEMP_PWC_Sales_Report_SP_
not be
If {TEMP_PWC_Sales_Report_SP_