Temp variables not working within xlate, post proc

Johnny, will your data always look like “pat id ##”?

If so, you can treat this like a list

Example tcl fragment inside an xlate:

Source: 1(0).0(0).0(0).PID.#3(0)

Tcl: set xlateOutVals

2]]

Destination: whichever outbound field you want to use (or a tmp var)

Note that you probably don’t need to use temp vars for this at all.

Here’s some sample code you can use for testing this logic:

Stick the code in a file called test.tcl and then run it from the command line with “tcl test.tcl”

In your document screen shot it looks like you are trying to use the temp variable before you set it to anything meaningful.

Try echoing out the value of your temp variable and I think you will see it has a value of “declare”.

You need to feed your csubstr command somehting from the xlateInVals coming into your TCL code to set the @spilt_pid_3_0 temp variable going out.

Johnny,

Assuming your inbound variable is “R1P12345”, set up a copy statement that has your single source field and your two destination fields.

Figuring out why someone else’s code is having a problem can be some fun but if I already have a proc that does what I need I take the path of least resistance and use it.

So forgive me for offering a quick alternative instead of digging in anymore at this point.

If you are saying you will always need to split a given field on ” ” (spaces) then look at this URL where I posted a how to of our generic proc that splits a field using the specified separator (a space in your case I think).

<a href="https://usspvlclovertch2.infor.com/viewtopic.php?t=1570&&#8221; class=”bbcode_url”>https://usspvlclovertch2.infor.com/viewtopic.php?t=1570&amp;

Johnny,

I do need to ask one question though. Is the region going to be “R1” or something similar everytime or will it be a two digit number?  I’m assuming this is just an oversight because you specified a range of “0 2” on the first variable and a range of “2 10” on your second variable.  This will make the character at the end of the first variable the same as the first character of the second variable.  Please clarify for us the exact form of the data.

Once again, assuming your inbound value will always be in the form of   “R1P12345”, set up a copy statement as below.  I have taken the liberty to fill in the fields mentioned in your document.

First, you can get rid of the “declare” entries in the xlate.