sshaikh
New Contributor
Joined 3 years ago
User Profile
User Widgets
Contributions
In XML Document how to replace \\ by \
Hi, The Input data is in XML format, There are multiple array and inside that in some of field contains double slash and need to replace it with single , we tried to build json expression like below in mapper: Can anyone help with this. if anyone have any alternate solution then please let us know.Date format issue.
Hi All, I have data type at input as a date fuction and expected same at output. But in mapping I need to keep as blank for the dates are invalid like 0001-01-01 or dates older than 2008-01-01. When I am trying to make an expression in mapper its not working, when I am making it in string type then its working. Anyone can guide on how to make an expression so output should be in Date function only. I have used below expression $Date < 2008-01-01 ? " " : $Date -----> Not worked $Date.toString() < 2008-01-01 ? " " : $Date.toString() -----> Worked but data type converted into String which is not desired. Date.parse($Date, yyyy-MM-dd) ----> Not Worked. I have tried with Type convertor and Date-Time Extractor type snaps but these snaps output is Date-time type.Re: File Size Differences
Hi @alchemiz Good day,I have observed the input and output format of file. There was, for input proper structured json file file was there but for output json structure in a single line. I think the space utilization in proper format is reduced in output so its size reduced. Thanks @alchemiz. Is there any way in Snaplogic by which we can get the same structured for output just like input structure?Re: File Size Differences
@ptaylor File Reader(Json File)>>Json Parser>>Json Formatter>>File Writter If I read and write the file using above pipeline I am getting the reduced File Size at end. Why there is Difference in file Size ? Is there difference due to conversion from DOC to Binary and vice versa ?
