Originally posted by: SBurra

Hi,
Is it possible to insert a <NL> after a record at Functional Map level? (in the Map Rule?)

Appreciate your reply with suggestion..

Venkata C Burra
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender
#DataExchange

Originally posted by: TimUK

The correct way to do this is to add <NL> as part of the terminator of your record.
Another way is to add "<NL>" to the end of the last field in your record and it will appear before the record terminator (if any is defined)
Tim
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender
#DataExchange

Originally posted by: SBurra

Mr.TimUK, yeah I understand what you are trying to tell me here.. But I don't want to add to the terminator of the record, in fact, I do not want to touch the type tree at all, but instead I should be able to give the <NL> at the MAP RULE..

FYI - This is what I did..

In my Functional Map Rule, I added SYMBOL(13) + SYMBOL(10) for <CR><LF> and it worked fine for me.

As I am new to this tool, even though the above SYMBOL worked fine for me, I'm still not sure of how <NL> can be given at the MAP RULE? The reason being, I do not see any SYMBOL numeric for <NL>.. (or) probably I'm missing something out here..

If you know a way out for this, please reply.. Appreciate your reply. :) Thank you Mr.TimUK

Have a great day Sir!!!!

Venkata C Burra
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender
#DataExchange

Originally posted by: TimUK

SBurra
Not sure exactly what you mean now so this is my last attempt.

Instead of using SYMBOL(10) + SYMBOL(13) use "<NL>" and it'll have the same effect.

=f_myfuncmap(blah, blah, blah) + "<NL>"

Tim
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender
#DataExchange

Originally posted by: SBurra

I totally agree with you and I exactly did the same in my Functional map.. When I enter <NL> at the end as you said in double quotes, my Map is saved fine but when I run the Map, I am getting invalid <NL> argument in the functional rule error..

I did it this way.. F_somemap(blah blah.. ) + "<NL>"

This is giving me error in the output and I was curious to find the reason why and hence posted the question..

Thanks anyways for the reply..

Venkata C Burra
#IBMSterlingTransformationExtender
#DataExchange
#IBM-Websphere-Transformation-Extender

Originally posted by: karthikpc

hi,

you can try using SUBSTITUTE function inside the functional map.

SUBSTITUTE(File_Input, "" , "<NL>")

give it a try.

Cheers
#DataExchange
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender

Originally posted by: SBurra

Cool.. Kathik.. That worked.. Thanks a lot for the reply. Appreciate that..

Venkata C Burra
#DataExchange
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender