Does anyone know of a Function in Mongoose that returns special characters (tab, new line...)

Is there a Function in Mongoose that can be used as a parameter in SUBSTITUTE that returns a special character (for example the tab newline characters)?

I would like to set up an Event Handler that uses these special characters in the email body, resulting in something like the following:

1. PROPERTY({first_property})

2. PROPERTY({second_property})

3. PROPERTY({third_property})

Thanks

John Keegan

downloadexport1519_1.zip

Find more posts tagged with

Accepted answers

All comments

unknown

I've always just put my carriage returns in the body of the email of the event action itself and it works for me. It doesn't require special functions.

unknown

Thanks 1362426, but what if I wanted to put a <tab> between two words? How can I do that?

Also, I am noticing that if, in the email body, I put text followed by a property value followed by a carriage return, if the Propery Value is null (or blank), the carriage return shows up in the email. If the Property Value is not null, the carriage return does NOT show up in the email. I am thinking that if I use a function insert a carriage return, it might be more consistent.

Regards,

John Keegan

unknown

I would try enabling HTML for your body and then using the HTML commands to do what you are wanting, like

dean-bradko

I would do this using form script for much better control.

If using VB, there are some old school constants defined, like vbTab and vbCRLF. For CR, I often use Environment.NewLine. For tab in C#, I think the easiest way to get a tab is ControlChars.Tab.

That said, you can get any ASCII character using Chr(asciiCode).

unknown

I'm struggling with this same idea. I have an INFOR provided event that scans SLItemLocs on a schedule and returns any rows where the QtyOnHand field is negative, and sends an e-mail to our inventory specialist for review. The code works, but the output is in a big text blob. I'd like a carriage return between rows of data.

Here's the code as provided by INFOR:

Event Handler
Name:QtyOnHand
Handler Description: Item quantity on hand available
Applies to Objects: SLItemLocs

10 Load IDO Collection
IDO("SLItemLocs")
PROPERTIES("DerIWhseQtyOnHand, Item, ItmDescription, QtyOnHand, ItmPMTCode")
FILTER("QtyOnHand < 0 AND ItmPMTCode='P'")
SET(R(rsBAH) = RESULT)

20 Finish
CONDITION(ROWS(rsBAH) <= 0)
RESULT("No quantity in negative")

30 SET VALUES
SETVARVALUES(vCurRow = 1, vItemList = "")

40 BRANCH
CONDITION(V(vCurRow) > ROWS(rsBAH))DEST(80)

50 SET VALUES
SETVARVALUES(vrsItem = P(rsBAH, V(vCurRow), "Item"), vrsDesc = P(rsBAH, V(vCurRow), "ItmDescription"), vrsDerQty = P(rsBAH, V(vCurRow), "DerIWhseQtyOnHand"), vrsQty = P(rsBAH, V(vCurRow), "QtyOnHand"),vrsPMT=P(rsBAH, V(vCurRow), "ItmPMTCode"))

60 SET VALUES
SETVARVALUES(vCurRow = 1+V(vCurRow), vItemList = ""+V(vItemList)+" " + V(vrsItem) + " " + V(vrsDesc) + " " + V(vrsQty) + " " + v(vrsDerQty))

70 GOTO
DEST(40)

80 SEND EMAIL
TO("user@company.com")SUBJECT("Negative on hand quantities")HTMLFORMAT(FALSE)BODY(SUBSTITUTE("The following items have a negative on hand quantity:{0}", V(vItemList)))

Observations
Event Trigger

Event Name: QtyOnHand
Condition: CONDITION(TRUE)
Condition ReTest Interval: 80,000 (86,400 0 => 24 Hrs)
Trigger Reset Interval: 80,000 (86,400 0 => 24 Hrs)

The output looks like this:

The following items have a negative on hand quantity: 50240 CONNECTOR, BACC45FN12-12P BOEING -2.00000000 765.00000000 50790 WASHER, LOCK-SPRNG, HELICAL, MS35338-40 -72.00000000 -72.00000000 52722 CERROTRU, 5800-2 -32.88342106 1667.11657894

I'd like it to look like this:

The following items have a negative on hand quantity:

50240 CONNECTOR, BACC45FN12-12P BOEING -2.00000000 765.00000000

50790 WASHER, LOCK-SPRNG, HELICAL, MS35338-40 -72.00000000 -72.00000000

52722 CERROTRU, 5800-2 -32.88342106 1667.11657894

Is there a way to insert an HTML command like into STEP 60 that would allow the body to parse the carriage return within the body of the e-mail?

ie. 60 SET VALUES
SETVARVALUES(vCurRow = 1+V(vCurRow), vItemList = ""+V(vItemList)+" " + V(vrsItem) + " " + V(vrsDesc) + " " + V(vrsQty) + " " + v(vrsDerQty) + )

(That doesn't work, btw.)

unknown

And per usual I then stumble on the answer. By assigning a new variable in step 30 with the value " " I am able to successfully insert it into the step 60 and have it express properly.

30 - SET VALUES

SETVARVALUES(vCurRow = 1, vItemList = "", vLineBreak = " ")

60 - SET VALUES

SETVARVALUES(vCurRow = 1+V(vCurRow), vItemList = ""+V(vItemList)+" " + V(vrsItem) + " " + V(vrsDesc) + " " + V(vrsQty) + " " + V(vrsDerQty) + " " + V(vrsLoc) + " " + V(vLineBreak))

Rene Bottern

Have you tried adding

Product Update Session, IPS, EAM, CS FSM, HCM-20200716 1701-1.mp4

Copyright © 2025 Infor. All rights reserved.