Personalization, Customization and Productivity Tools

[BShockley]

Is it possible to print the first line of the extended item description on a form such as the picking sheet?

The CI_ExtendedDescription file seems to have a line break character.

I basically need everything in the description field before the first line break.

Can someone share a formula with me to accomplish this?

4.4.0.3.

[fastasset · Accepted solution]

Try this formula = LEFT({SO_PickingSheetWrk.ExtendedDescriptionText},INSTR({SO_PickingSheetWrk.ExtendedDescriptionText},CHR(13))) where the instr function looks for the carriage return.

[BShockley]

I think it works.

Thanks!

[Gator]

You may want to make this conditional to ensure that there is a carriage return.  Otherwise, I believe the function will not return anything.