String manipulation

[Data_consumer]

Hi,
I need to modify the following string by adding the column Date to the string.
What is the easiest way to get this done? Tried string manipulation, but was not able to get this to work

{ “fromdate”: “2000-01-01”, “todate”: “2030-12-31”,“asofdate”: $Date$,“datagroupings”: 4}

[takbb]

Hi @Data_consumer, so do you currently have the string in json format and you want to insert the value of $Date$ into it at the position shown, or are you trying to create the entire string from scratch?

[Data_consumer]

HI @Takbb!

I’m trying to create it from scratch… the $date$ is the only “data”, the rest is added (typed to string manipulation node) need the string for a post call body…

Thanks!

[takbb]

Ok, the other question I should have asked: is the Date column actually a Date datatype or is it already a string in the required format?

• actually I don’t think it matters as if it is a Local Date column, the format you are producing yyyy-MM-dd is what will output anyway.

Try this:

join("{ \"fromdate\": \"2000-01-01\", \"todate\": \"2030-12-31\",\"asofdate\": \"",$Date$,"\",\"datagroupings\": 4}")

(every double quote within the string needs to be escaped as shown. Is that what was causing the problem?)

[Data_consumer]

@takbb works like a charm! The double quotes we the ones giving me the trouble, learned that one also now!

Thanks & enjoy the weekend!!

[takbb]

Glad it worked for you @Data_consumer. Have a good weekend too.

And thanks for marking the solution.