How can I replace the cell content with ****

Hi Everyone,

How can I do this?

image

Thanks in advance!

Hi,

You could use the String Manipulation node with the regexReplace function:
regexReplace($words$, “\\B\\w\\B” , “*”)
(note: replace $words$ with the name of your column (double-click the name of your column in the column list of the configuration dialog).
-Don

3 Likes

Thanks for your help!

But I got this msg

image

How to fix it?

Here you go @HKuser : replace cell content.knwf (6.2 KB)

Input:
image

Output:
image

3 Likes

Hi. The function as displayed in my post is correct, but apparently you must type it in to the String Manipulation node instead of copying and pasting from my post. Sorry for the confusion. -Don

3 Likes

Really thanks for your help!!!

2 Likes

Hi @dnaki, you may already now realise this but if you are including source code, or other parts that you don’t want the forum software to format/alter you can highlight that particular part of your message and then press the “Preformatted text” button. This causes it to wrap the text in apostrophe characters so that it is displayed as written.

So then instead of your code appearing like this:
regexReplace($words$, “\\B\\w\\B” , “*”)
it would appear like this (and can be copied/pasted):
regexReplace($words$, "\\B\\w\\B" , "*")

image
hope that helps

5 Likes

Thanks, Brian. Good tip!

2 Likes

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.