[Hina Siddiqui]

Yes Yes, I do have that doc saved. I will try using it in an xlate.

Thanks so much Jim

[Hina Siddiqui]

Hey Jim,

Actually we are finding it difficult to parse it inside the Xlate. This is happening because our field FT1_7 contains value like “cbc & abc” . We need to map the exact string to the outbound. But because out string contains “&” which is a true delimiter, as soon as it passes through the variant, cloverleaf breaks the string value thinking “&” as a delimiter.

Is there a way to handle this in xlate?

[Hina Siddiqui]

hey Jim, Thanks a lot. Its working now.

I was getting an error “unrecognized lexical character” but this was because i was putting the character in the if condition like

IF @strtemp eq =,

then i assigend the comma to a variable and then used in IF condition and it started working. 🙂

[Hina Siddiqui]

Just another quick info. My output looks like the image i have attached. As you can see, the 3 new OBXs that were created, were placed in the end and all those 3 new OBXs dont have the values from the OBX preceding to NTE but have values from the 1st OBX in the group 🙁

I tried to debug a lot but just stuck here and not able to move forward.

[Hina Siddiqui]

yes that is correct, I am trying to create a new OBX. The output should look like as follows

MSH|

PID|

PV1|

‘

‘

‘

‘

OBX|1

OBX|2

OBX|3

OBX|4

OBX|5|will have value of OBX 4

OBX|6

OBX|7

OBX|8|will have value of OBX 6 fields

Hope i made more sense

[Hina Siddiqui]

Thank you so much everyone. I will try different methods and get back with the results

[Hina Siddiqui]

i did try even 10000 but the issue that comes is that it processes 10000 records and stops. Does not proceed to next 10000 records.

Could you shed some light on this issue?

[Hina Siddiqui]

Hi

The code definitely helped me understand the approach. But i am trying to do it in xlate. Is there a way i could do there. Like using the already declared variables by cloverleaf

[Hina Siddiqui]

Thanks a lot.

Really Helpful 🙂

[Hina Siddiqui]

I understood the clock temp variable. But how can we declare current date. Could you give me an example

Thanks a lot

[Author]

Replies