Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I want to remove some text from the beginning of a field by expression / script. The seperater is '#', but it is not always at the same mid point of the field. Could anyone help. Please see below ....
123;#Peter Jones
56789;# John Smith
I want to show .....
Peter Jones
John Smith
Any thoughts welcome
Thanks
Phil
SubField(YourField, '#', 2) as Name
SubField(YourField, '#', 2) as Name
Hi,
use subfield()
try like
subfield(fieldName,'#',2)
Regards
maybe subfield
load
field,
trim(SubField(field, '#', 2)) as newfield
Inline [
field
123;#Peter Jones
56789;# John Smith
];
Got it.
Thanks guys
Phil