ContributionsMost RecentMost LikesSolutionsRe: Create a MD5 checksum for a file write Thanks! I didn’t think of this. Create a MD5 checksum for a file write Hi, I need to create a MD5 checksum for a file that is going to be written to and SFTP server. The only way I have figured out how to do this is to write the file to a groundplex server using the file:// protocol and then run a linux command on the file written to create the checksum file. Is there an easier way to do this? SolvedRe: Strip white spaces out of Excel To filter out empty rows you can use a filter snap with “$ != {}”. Re: Substring a field inside of an array? Not sure, but I was able to get it to work with the first suggestion. Re: Substring a field inside of an array? I tried toString because lastUpdateDate was being returned the same way but as it was an Array. Re: Substring a field inside of an array? I have tried mapping already with the following. jsonPath($, “$studySiteChecklist.checklist[*].lastUpdateDate”).map(x => x.substr(0,10)).toString() But I got the follwing which is not correct. Thank you for the suggestion Bill Re: Substring a field inside of an array? Wow, I never used the pass through with mapping root. I was able to get it to work. Thank you! Bill Substring a field inside of an array? I’m trying to substring the field $studySiteChecklist.checklist.lastUpdateDate but I can get it to keep the same output as the input. Any ideas? [{ "country": "a", "studySiteChecklist": { "checklist": [{ "lastUpdateDate": "2017-08-27T00:00:00Z", "commentsIndicator": "0", "comments": "0", "yesNoIndicator": "0", "questionNumber": "0", "checkListNumer": "0", "question": "0" }, { "lastUpdateDate": "2000-08-27T00:00:00Z", "commentsIndicator": "0", "comments": "0", "yesNoIndicator": "0", "questionNumber": "0", "checkListNumer": "0", "question": "0" }] } }] Output needed: [{ "country": "a", "studySiteChecklist": { "checklist": [{ "lastUpdateDate": "2017-08-27", "commentsIndicator": "0", "comments": "0", "yesNoIndicator": "0", "questionNumber": "0", "checkListNumer": "0", "question": "0" }, { "lastUpdateDate": "2000-08-27", "commentsIndicator": "0", "comments": "0", "yesNoIndicator": "0", "questionNumber": "0", "checkListNumer": "0", "question": "0" }] } }] S3 Metadata on file write I have a need to write S3 metadata when writing a file. Has anyone ever done this? Re: Json Array value to column formating tstack: { EnvelopeID: $EnvelopeID, RecipientId: $RecipientId }.extend($.TabStatus.map(x => [x.TabLabel, x.TabValue])) This worked great! Thanks!