Recent content by JasonKaufman

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...