Tuesday, September 22, 2020

Read CSV File in ICRT

 

ICRT





let $x := $input.fileEvent[1]/content 

return replace($x,'"id","Name"
','')



for $i in 1 to  count(tokenize($temp.tmp_Source ,'
'))

return <ID>{

replace(substring-before(tokenize($temp.tmp_Source ,'&#xD;')[$i],','),'"',"")}</ID>



for $i in 1 to  count(tokenize($temp.tmp_Source ,'&#xD;'))
return <NAME>{
replace(substring-after(tokenize($temp.tmp_Source ,'&#xD;')[$i],','),'"',"")}</NAME>







let $x := unparsed-text('file:///C:/Users/informatica/lmp_support/INFA_API_Shared/API_ClientConfig/Config/Source1.txt')
return replace($x,'"id","Name"&#xD;','')