Remove first four characters from front of a text field
I need to remove the first 4 characters of a text field. Specifically, "<li>" ie. the html code for a "list item"
I cannot use find/replace because the same "<li>" characters also appear later in the same field and those are needed. Just the first occurrence needs to be stripped (removed)
I have struggled with substitute and failed and looked into the character parsing functions like 'left' - but these remove all the text after the first 4 character and I need to do the reverse.
Data in the field (product specifications) varies from record to record
Data is typically entered into the field via csv file import. Sometimes data is just entered from scratch
Thanks in advance