Altering description of products 6

[AdamRicko]

Hi Folks,

Im trying to take the start of a description and put in a different field e.g.


75cl CHATEAUNEUF DU PAPE NALYS 05/06

all the descriptions have the size of the item at the beggining but i want to effectively Cut these from the desciption so i can place elsewhere on my report. The size of the items vary e.g. 75cl , 550ml, KEG, FIRN.

So ideally

75cl CHATEAUNEUF DU PAPE NALYS 05/06

would come out as CHATEAUNEUF DU PAPE NALYS 05/06 with 75cl shown seperately.

Many Thanks in advance,

AdamRicko


CR2008

 

[AdamRicko]

Scrap the above, have just found a table with the sizes on. Allthough now i need to trim the sizes off the description. As i said before the sizes vary but their is a space between the size and the product. Would trimleft work or does that just get rid of blank space?

Cheers

 

[IanWaterman]

Try

mid({yourfield}, (instr({yourfield}," ")+1), length({yourField}))

Ian

 

[lbass]

Or more simply, you could use:

mid({table.field}, instr({table.field}," ")+1)

-LB

 

[CR85user]

Or - if the description is the same as the other seperate field indicating size:

Replace({table.description},{table.size}&' ','')

'J







CR8.5 / CRXI - Discovering the impossible

 

[AdamRicko]

Cheers folks, tried all 3 and they all work

Greatly Appreciated,

AdamRicko