Extract the last substring English word

Question

Hi all,

Please assist with my following biz requirement.

Is there a way to extract the last English word in a string without spaces?

InputOutputbclmainediteditextractreferraldatadatapxextractdatetimetimepxextractidentifieridentifieradjustmentreasoncodecodereportingflagflagreportingdatedatedeletedauditidid

padawanRZ · Answer

looking for this, will have to import the python code then

https://grantjenks.com/docs/wordsegment/#

Prometheus · Answer

@padawanRZ You could use a dictionary API to reference like this one https://dictionaryapi.dev/ to look up words, but you'd need to create a macro that created every substring possible of each value then replaced "" in the free dictionary API (https://api.dictionaryapi.dev/api/v2/entries/en/) to query for every possible word. If you had 100 records to validate, that workflow would probably take a really long time.

apathetichell · Answer

you would need a list of potential last words - otherwise this is not possible in alteryx. I do not believe you could get what you want even using an AI unless you also included a rule structure (ie the word - with the most characters- otherwise it would not know if you wanted state or estate.)