Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Add leading character 1

Status
Not open for further replies.

skootsu

Programmer
Sep 27, 2005
21
US
Can anyone tell me how to take a field and add a leading and ending character? Example, my report will list Part#, *Part#*, Part Description, Location, *Location*, Warehouse. IE, the part# and Location fields are within *'s. Any ideas? I'm thinking its a string function but thats as far as I can get.
Any tips would be greatly appreciated.
 
Create formulas like:

"*"+{table.part#}+"*"

Note that asterisks are used in CR as wildcards.

-LB
 
Thank you, Thank you!! Just started at a new job with all new tools. Had no books, mgr was holding out ;)
Now I'm off and running.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top