Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
GuruGPS
Contributor II
Contributor II

Subfield

How do i remove . [NULL] from a field name called customer. Example of a customer name is " . [NULL] XXXYXX BIZZ & ZXXX AGJELAT BIZZ:    i need to remove  ". [NULL]"

Note that not all customer names behaves like that, only a few

Labels (1)
1 Solution

Accepted Solutions
Or
MVP
MVP

Replace(Field,'[NULL]','')  should do the trick. Subfield is something else entirely...

View solution in original post

2 Replies
Or
MVP
MVP

Replace(Field,'[NULL]','')  should do the trick. Subfield is something else entirely...

GuruGPS
Contributor II
Contributor II
Author

Thanks it works well