AnsweredAssumed Answered

Remove first four characters from front of a text field

Question asked by dannyred on May 16, 2009
Latest reply on Nov 26, 2014 by ShunichiMuto

Title

Remove first four characters from front of a text field

Post

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

Outcomes