Need to remove ~ from repeating field

[Ariba Jones]

I have an xlate setup for an outbound thread.  I need to remove the ~ in the field of one of the segments in the message.  For some reason, the ~ is at the beginning of the value in the field when the message is sent to the receiving system.  This is causing the field not to populate correctly in the receiving system.  I can’t figure out how to get the ~ removed from the field.

Here is what Cloverleaf receives in the message.

PRA|10282^^MSOW^^^||||7^Internal Medicine^American Board of Internal Medicine^C^~7^Internal Medicine^American Board of Internal Medicine^C^~7^Internal Medicine^American Board of Internal Medicine^C^~143^Nuclear Medicine^Certification Board Of Nnclear Cardiology^C^|01046667A^SL^IN^20090630~12345^SL^LA^20100131~K4042^SL^TX^20100531~BD7370834^DEA^LA^20100630~C0104593^DEA^TX^20090228~1152749^Medicaid Provider^^~1629073457^NPI Number^^~30451^State Narcotics Number^LA^20090501~4F090^Medicare Provider^^~H54655^Medicare UPIN^^||

Here is what it looks like went sent to the receiving system:

PRA|1281^^MSOW|PRI^PRIMARY|Act||C^Cardiology^Internal Medicine^American Board of Internal Medicine^C~7^Internal Medicine^American Board of Internal Medicine^C~7^Internal Medicine^American Board of Internal Medicine^C~143^Nuclear Medicine^Certification Board Of Nnclear Cardiology^C|~12345^SL^LA^20100131~~BD56789^DEA^LA^201006308~1152749^MCD~1629073457^NPI~^^LA^20090501~4F090^MCR~H54655^UPIN|A

I only need to send the LA state license field to the receiving system so I have code to only send that particular license.  However, because the LA license is in a repeating portion of this field, the ~ is still in front of it when sent to the receiving system.  I need to remove that ~ seen in the second example I provided.

Does anyone have any suggestions?

Thanks in advance.

Ariba Jones

Topic

[Jim Kosloskey]

Ariba,

It looks like you are using the field repeition counter (something like %f1) for boththe inbound and outbound. Because you are not sending every repetition, you need to manage your own outbound field repeitition counter (something like %f99). You would still use %f1 for the inbound but use %f99 in the outbound field address path.

You will need to add to your counter appropriately and make sure it is initialized properly at the start.

You can reference your counter (and any repeition counter) in an Xlate Action (like a MATH ADD) by placing a $ in front of the counter – like this $%f99.

email: jim.kosloskey@jim-kosloskey.com 29+ years Cloverleaf, 59 years IT - old fart.

[Ariba Jones]

Jim,

I have never used the MATH:ADD function before.  Am I supposed to keep my %f2 in the Source field and use $%f89 in the destination field?

Can I just setup my counter something like this?:

%f89 = %f89 + 1

I am not sure.  I understand what you are saying needs to happen.  I just am trying to figure out how to do this.

Thanks,

Ariba

[Author]

Replies