Hi @skorpionaa

Could you share your source xls?

 

Thanks,

Danilo

I suggest you to use the transformer StringSearcher for find Text.

https://docs.google.com/spreadsheets/d/1B0CQyFeqxg2wgYHJpFxLIzw_8Pv067p0cwacWk0Nc4o/edit?usp=sharing

 

Column A Please

I cant figure out Please help me out ion this

Hi @skorpionaa,

Have you tried using an AttributeSplitter or SubstringExtractor? Along with Danilo's suggestion on the StringSearcher, these are good string manipulating transformerts to start with.

For example, grabbing the .rar or ,zip, you could use the AttributeSplitter to split on the '.' as a delimiter. Please give these transformers a try and let us know how it goes for you. If you get stuck, please feel free to share your workspace so far and we can try to get you back on track (:

I'm not 100% clear on the requirements, but if you want to pick out the strings of Arabic words that are separated by hyphens (-) or forward slash (/) you could use regex in a string searcher

( \p{Arabic}\s]+)

This would return a list which you could then rename to attributes as necessary