on 05-04-2011 5:08 AM
Hi Experts,
i have Scenario proxy to file
from source side i got input values in one field(long String). in the target side i need to split that field
finallly i need get the out put file like this
q2344eretrnnsd sewewerereefre wereretrtrtreeterte ertrterwytdyt rtretyeytyutueyt
sdgfghfhyghhjhj sdfgfdhdghgjgjh sdfgdfhgfhjgjgjfgh dfgdhdgghgh dfghfgfgfgfgfgf
sfdggggggggddf sdfdfsddfdfdfdfd sdfdfdfdfdfddfdfs sdfsdfdfdsfd asdfsdafdsfds
the problem is while place file in the target directory the file need save as according to the "version no" (it is included in the long string of source field)
file name should be change according to the "version no"
so please suggset to me how can i change the file name according to the version no which is include in the long string in the source side
Thanks in advance
Hi,
First split that long string and retrieve the version number from that and then use dynamic configuration.
/people/shabarish.vijayakumar/blog/2009/03/26/dynamic-configuration-vs-variable-substitution--the-ultimate-battle-for-the-file-name
Thanks
Amit
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi All,
Thanks for the reply
for using the variable subtitution we need the particular field value which we want to set as a file name
but in my requirement i will not get any field values separatley. it alway s coming into as long string field
please suggest me how to acheive it
please correct me if anything wrong
Thanks in advance
Hi,
are you doing mapping? if yes then
write a UDF to substring the required version no and append the version no in file name and return the file name.
*Set the ASMA properties for File name in Advance mode in ID
Refer the below links for ASMA properties and Sample UDF
/people/michal.krawczyk2/blog/2005/11/10/xi-the-same-filename-from-a-sender-to-a-receiver-file-adapter--sp14
http://help.sap.com/saphelp_nw04/helpdata/en/43/03612cdecc6e76e10000000a422035/content.htm
Regards,
Manikandan
Hi Mani kandan,
thanks for the reply can you please tell me one more thing in FCC
source side we have only one field which is long string so we need put the value of that field in to the below format in target location
source (field value==<line>sapsdnforumsprocessintigration</line>) ocurs multiple times
in target file it has to appear as in below format.
sap sdnforums processintegration
sap sdnforums processintegration
sap sdnforums processintegration
sap sdnforums processintegration
please suggest wat type of file cotent conversion parameter rquired to achive this in the receiver communication channel
Thanks in advance
Edited by: katakoti on May 17, 2011 8:44 AM
Edited by: katakoti on May 17, 2011 9:28 AM
katakoti
you cannot solve itso simple. besides de file name that comes from the source system, you need to append the version number, value that you dont know at runtime. if the version number has not requiered you can solve your scenario with a UDF--> see Dinamyc file name blogs (Dynamic configuration) the isna particular blog from Michal K. that has the code already.
the solution for your issue is not so simple. i reccomend you to meet the functional source system and check with him if the version number could be omited or maybe replace it with a timestamp in the file, configuration that is standard in the channel. the timestamp is other way to version files.
hope that help.
Regards
RP
Hi Ravi,
i have the sample out put file based on that i can decide the field lengths(the length of the eachfiled is 83 charecter).But the FCC parameter LINE.filedFixedLength(line is input filed name) is not work for Single field which is containg the long string.
NameA.absoluteRowWidth=<noOfColumns>. this parameter deviates entire string into no columns
like this
input =
sapsdnforums
output:
sap
sdn
forums
i wnat the output like this
sap sdn forums
Thanks in advance
Edited by: katakoti on May 25, 2011 11:41 AM
>>the file need save as according to the "version no" (it is included in the long string of source field)
You can try using dynamic configuration concept.
Refer the below wiki:
-Rahul
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
10 | |
10 | |
9 | |
7 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.