Nulling GT1 that has a *

[Steven Lindsey]

Not to get into a long store but we have sometimes in our GT1 that as * in the GT1_3 and GT1_21.  We have just been removing the * but now the want us to delete the entire line.  Here are screen shots that I have now.  I’m trying to think of the best way to do this.

Topic

[Tom Rioux]

I see a tilde in GT1.3 but can’t tell if it is there in GT1.21.   Are these repeating fields?  Can you mock up some data to place in there to show us what you mean?

If it is repeating fields, you can probably just use the lvarpop to remove the line out of there.

Tom

[Gary Atkinson]

regsub with replace with null?

[Steven Lindsey]

It is a repeating field.  Here is what the message looks like and I want to delete the GT1 if it as a *

[Gary Atkinson]

Deleted the whole segment or just the field?

[Steven Lindsey]

The hole GT1 segment

[Gary Atkinson]

I would put your iteration inside an IF.  Only copy if the * is not found.

[Steven Lindsey]

can you give me an example

[Gary Atkinson]

Iterate on your base

    Copy GT1   temp variable (set some constant)

    IF constant found

    Copy GT1

[Tom Rioux]

One thing you may want to consider when removing the GT1 segment is the numbering of the Set ID’s for each segment.   The downstream application(s) in question may use this (or GT1.15) to consider the priority for each of the Guarantors.   If this is the case, you may need to renumber your guarantor segments when sending the message outbound.

Tom Rioux

[Author]

Replies