i have as small issue
i have field value as “ws/08/0001” in this want to add some text in between “ws/” and “08/0001” supposei want to add dept in between that how can i do
i want format in this way “ws/dept/08/0001”
Subject: how to insert text in between someother text
I’ve made a lot of assumptions, like you want everything up to the first / then your text and everything else.
@Left(fieldname;“/”) + “/” + “dept/” + @Right(fieldname;“/”)
Subject: how to insert text in between someother text
From Help:
@ReplaceSubstring( sourceList ; fromList ; toList )
Parameters
sourceList
Text or text list. The string whose contents you want to modify.
fromList
Text or text list. A list containing the words or phrases that you want to replace.
toList
Text or text list. A list containing the replacement words or phrases.
Also - here is some more info that might be helpful.