Search results for query: *

I'm using Crystal XI I am wanting to create a report which shows the inventory value of a product for each month of a given year. The value of the product will change randomly depending on when goods were sold. For example, a product valuation for January 2018 could return the valuation from...

Thanks fisheromacse, your formula works as intended and I was able to modify it some for other non-pk instances.

I have a field, {tblProduct.Description_1} where "Pk" or "pk" or "PK" may or may not exist somewhere withing the string. If it does exist, I want to pull out that 2 character string along with the the 2 characters to the left of the 'pk' string as this data would be a number (such as 1,2,10, 11...

sorry lbass...i had included the output showing the productcode then the description in my output. I took your 2nd formula and tweaked it a little so now it is Replace(Replace({table.field},chr(13),''),chr(10),'<CR>') Thanks much for your help! The next problem ends up being when this long...

I tried "Replace({product1.long-description},chr(13)," x ")" and the data now look like: 0031431242|bt boys gry x x Product Testing Required-CPSIA Protocols-Lead in Substrates Section 101 CPSIA Phthalates Section 108 CPSIA: x R3149 (Navy & White) H311-1563 Pass exp. 4/13/16 I...

I am needing to create a CSV file using a long description field that can be of various lengths and could look something like the following bold type: bt boys basics gry 0-6 months Product Testing Required-CPSIA Protocols-Lead in Substrates Section 101 CPSIA, Phthalates Section 108 CPSIA...

Thanks to both of you for the help! I shall test it out and see if Betty's formulas do the trick

I have name data that needs to be split into first and last name. However, the data in this field is not standard. Some data just has the first name, some is standard with first name, space, last name. Others have standard with first name, space, last name with either a "/" with no space after...

works perfectly, Thanks so much for your help and patience Pete!

I am using CR XI My data is a csv file looks like the following with "<07>" as the delimiter: B.HL.HL: HL<07>3<07>1<07>25 B.HL.N1.N1: N1<07>WH<07><07>93<07>00806 B.HL.HL: HL<07>4<07>3<07>26 B.HL.N1.N1: N1<07>SN<07><07>93<07>00809 B.HL.HL: HL<07>5<07>1<07>25 B.HL.N1.N1...

I have been able to get some of what I needed worked out but not all of it. I will submit a new post to deal with what I am looking for now.

anyone have a thought how to solve this?

the EDI data is copied from the 816 file and put into a CSV file and opened in excel. [apparently the edit function is not working, thus the added post]

I am using CR XI working with 816 EDI data My data looks like: B.HL.HL: HL<07>3<07>1<07>25 B.HL.N1.N1: N1<07>WH<07><07>93<07>00806 B.HL.HL: HL<07>4<07>3<07>26 B.HL.N1.N1: N1<07>SN<07><07>93<07>00809 B.HL.HL: HL<07>5<07>1<07>25 B.HL.N1.N1: N1<07>WH<07><07>93<07>00810 B.HL.HL: HL<07>6<07>5<07>26...

Thanks Andy...while that would normally work with no problem. I should have added that this report will be on a scheduler, possibly using groffautomation software - still playing with it, and then the run csv data would be scheduled to be emailed, so there would be no in between to doctor the...

I have CR XI, CR developer, product type: full I have a report that must be exported to CSV for upload of records to a website. The main data is in a group header with the headers on the Page Header section. I want the export to look like the below two rows...

Thanks for the help hilfy!!! I have been able to successfully underlay the text box with everything else coming out in the right places...

Attached is the sample pack list. I have marked it with the Group Header sections. I have tried putting the text box in the 1st Group Header and the other data in Group Headers below it with the 'Underlay' ticked in GH1. This did not work as the GH1 printed first then everything else. I fear...

We have a customer who wants a pack list with database items on the left side of the page and Return information on the right, as part of a text box. Based on the picture they provided this would cross the Group Header, through the Detail section and into the Group Footer. The Header is...

Perfect! thanks Charliy, that did it! Now i just gotta figure out why if i have the same data for each subsection, why the 3rd one has the last 5 characters on the next line... weird...