igormicev
Contributor
Joined 6 years ago
User Profile
User Widgets
Contributions
- 2.9KViews2likes0Comments
Re: Expression to keep leading zero in a number
Hi @mtran21 What is the desired length with leading zeroes? you could have examples like 00123, 01234, or 00001. Under the assumption that you know the length, for example 5 here, then you could do something like: ("00000"+ $ MyNum.toString()).slice(-5) and you’ll always be having leading zeros and lengths == 5. HTH2.3KViews2likes1CommentRe: Seclore encrypted file processing
You have to use a Script snap. It supports JavaScript, Python and Ruby. Here is an article that uses Javascript Achieve Custom 256BIT AES/CBC/PKCS7 Encryption in SnapLogic Using Script Snap - ⋮IWConnect The basic python support with the Script snap is limited to some basic packages, but depending on the encryption you might be able to make a decryption However, if you additionally have the Snaplogic RPE you can use the Remote Python Script and try with many of the python’s packages for encr/decr.2.1KViews0likes0CommentsRe: Parse Excel file with duplicate columns
Hi @mohit, You can read-in the excel file with duplicate columns if you have the un-checked the “Contains headers” in the next “Excel Parser” snap Then with a mapper, you can remove the duplicate column and introduce a row number (snap.in.totalCount) column at the same time, because in the next step you’d want to filter the first row that contains the real Headers, … so ending up with something like this: Example pipeline attached: IM_remove_duplicate_columns_example_2021_01_05.slp (7.7 KB) /Igor3.1KViews0likes0CommentsRe: Email snap with both pipeline variables and HTML table?
Hi @wpenfold You’re probably close to your goal. Make changes in your email sender snap like below: I guess your Template body is OK, i.e. in the HTML you should have something like ... <table> </table> <br> </body> </html> and before the email sender snap you should have a mapper like this one (note the $table object) that provides the $table: That should be enough /Igor3.4KViews0likes1Comment