This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Within a pipeline, how can I programmatically access the SLPROPZ file for a snaplex, and write the contents of the file out to the local hard drive?
We have over 500 snaplexes that we need to do this for, so manually downloading them all is not a goo...
I thought about creating a ticket to ask this, then realized others probably could use this information as well…
When writing a script for a JavaScript snap, one can define all the subroutines as member functions within the “impl” object:
var impl = ...
Summary: in the JavaScript snaps, what is the difference between doc.get(“something”) and doc[“something”] ??
Details and Background:
I am very well-versed in C++, SQL, and a smattering of other languages, and have been developing for a long time. B...
I’m looking for General Guidance, not a solution to a specific problem!
I have a lot of experience programming in server-side languages like C++, C#, T-SQL, PL/SQL, and others… but am very much a newbie at Javascript. (When my employers’ pipelines u...
Judging from the options available in the Aggregate Snap, I would expect it to work much like the identically named aggregate functions in SQL. SQL functions like COUNT, AVG, SUM, and MAX conveniently skip over NULLs and return the same values as th...
@aditya.gupta41 - you need to have a serious talk with your Business Analyst. The requirement is nonsensical and there is no way for you to meet it.
Text files are just straight textual data. CSV files add only minimal structure on top of that, i....
BTW, I saw you tried CHAR(10).
Did you try char(13)+char(10)?
Maybe just char(13)?
Or the inverse, char(10)+char(13)?
I’d try those – in that order – if you haven’t already.
Hi, @darshthakkar -
I agree the Excel file format is a different story.
And there has to be a way to embed linefeeds in a field there, else you couldn’t do it in Excel itself and get the line breaks back when you reopen the file later!
I suggest if y...
Just my two cents worth here: you definitely do not want to try to embed newlines within the interiors of fields in a CSV file.
Different programs parse CSV differently, but almost all of them treat the newline as an end-of-record terminator. That ...
@nmuppa - you mentioned queries.
Exactly what are you looking for here?
“%” is the modulus operator in JavaScript, Ruby, and Python.
If you really mean “queries,” which database system are you querying?
Microsoft SQL Server uses the % operator as wel...