Forum Discussion

donepr's avatar
donepr
New Contributor
8 years ago

Date Timestamp error while trying to use the "sql server update" snap?

Hi All, I’m trying to update the target sql server table using “sql server update” snap with the where condition “INSERTTS = $INSERTTS” (INSERTTS is the insert date timestamp) but I’m getting the ...
pipeline
koryknick's avatar
koryknick
Employee
4 years ago
Copy LinkReport

It’s the newline character in the string that is causing the issue. The dot notation for character matching in regex does not match newlines. After a bit of thought, we can also simplify the result by using the regex group capture syntax. Try this:

$notes.replaceAll('\n','').replace(/.*#IF:(.{9}).*/g, '$1')
JensDeveloper's avatar
JensDeveloper
Contributor II
4 years ago
Copy LinkReport

Thank you it works now. I get it now. Still improving my regex 🙂

  • jonesky's avatar
    jonesky
    New Contributor
    7 years ago
    Copy LinkReport

    Did you ever figure this out? The date time formats for SQL server are not compatible from what I can find.