Add a text format with the extsting values in a column

[JonamDeju]

Hey folks,

Let’s say, I have a column with a email address details with multiple rows and I want to add a specific word before the email address for each rows. How do i do that?

Any help would be highly appreciated!

Cheers,
Jonam

[gonhaddock]

Hello @JonamDeju
From your description it looks like a job for regex and/or string manipulation to me.
Can you provide a representative sample of your use case, and expected output?

BR

[JonamDeju]

Hey BR,

Thanks for pitching in!

Sure, here’s the example.

Many thanks,
Jonam

[gonhaddock]

Hello @JonamDeju
The simplest approach to me is to use a String Manipulation node with the following code:

join("username: ", $Imput sample$)

BR

[JonamDeju]

Thank you, this works!

Also, Do you know how I can add the email address inside a double quotes (" ") after the string “username:”

Jonam

[gonhaddock]

Hello @JonamDeju
Yes, I missed them:

join("username: ", "\"", $Imput sample$, "\"")

BR

[JonamDeju]

Yep, just sorted it out!

Thanks much for your help BR, really appreciate it!

Cheers,
Jonam