Forum Discussion

JensDeveloper's avatar
JensDeveloper
Contributor II
4 years ago
Solved

Map expression regex

Hi,

A simple one for the people that are expert in regex. I’m still learning it.
So, I have a key: notes that contains a value : #IF:SLG-01-SL + some text here”

My goal is to always get the 9 characters after an #IF:
My expression I tried in the regex and works: ([#IF:])(.{0,12})
But how do I put it into a mapper?
First i check whether the notes contains ‘#IF:’ if thats true it goes to the path where i need to do the regex in the mapper

$notes.replace($notes, /([#IF:])(.{0,12})/g)
but now it gives the string of the regex.

Regards

Jens

  • To fix the SQL EXECUTE error we changed the Query Type from auto to read and the ID was returned.  We have a feature request change into SnapLogic for the SQL INSERT snap.  Would like the option to return the ID in this snap as well.