How to use startswith() if want to extract a column start with a string

[XXX_Rosy_XXX]

How to use startswith() if want to extract a column start with a string

[binu_acs]

@XXX_Rosy_XXX StartsWith() function is for specific string, for example you wanted to find all the strings starting with the letter S then you can use StartsWith([Field],’S’), if you want it in a generic then use Regex formula

[XXX_Rosy_XXX]

below formula not doing anything. I want to replace those start with any string to be blank. If starts with number remains

if REGEX_Match([Specific Location],"\<[a-zA-Z]") then "" else [Specific Location]
endif

[aatalai]

@XXX_Rosy_XXX I would use the filter tool with StartsWith([Field],’what you want’)

and then use regex or some parse tool from the true output. Try and let me know how it goes

[binu_acs]

@XXX_Rosy_XXX in your regex formula update ^\D.*