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;','')