Trimming off

Question

Hi All,

Trying to trim or delimit of a name column. From  and .feyppsmoldixgt.com evertyhing is should move over from the name column to the output column. Any ideas to get this done because using the text to column and trim functions are not cleaning down the columns.

NameOutputFunctomloopNnJina-0::sunmazz-00288FunctomloopNnJina-0::sunmazz-00288venuscollector000venuscollector000uranucolumns524uranucolumns524uranucolumnsr5412uranucolumnsr5412uranucolumns118uranucolumns118SUN@00.43.00.700.43.00.7JupitersMarsHolder@T123456789TYT123456789TYTT123PTTXSaunar@xxxTTT01xxxTTT01XXXSXFarr@XXXSPVERO00.feyppsmoldixgt.comXXXSPVERO00XXXSXTarr@XXXSPVERO01.feyppsmoldixgt.comXXXSPVERO01Mars@00.88.00.900.88.00.9mitchmitch

Thank you,

JamesCharnley · Answer

@rmartinez4  I've added expressions to the formula that'll fix the new given inputs, but it's hard to know quite how dynamic the RegEx will be without knowing the full extent of the inputs that will come in. This should work in the short term at the very least until maybe someone can come up with something better if needed.

RegexEmails.yxmd

rmartinez4 · Answer

Hi Emmanuel,

@Emmanuel_G

both solution provided work well but I forgot to add the last 3. Is it possible to add the regex solution with the last 3 included.

XBXY-XX-1111.WAXI.COM                                  XBXY-XX-1111

VRAM40-TGAGAXDSTILLY-100.01.000.000       VRAM40

WSLO-XESX-XWTXA001(XX-XQCXX-XAX2)     WSLO-XESX-XWTXA001

Thank You,

Emmanuel_G · Answer

@rmartinez4

Find attached the way of doing this with some regex expressions.

Let me know if there is any issue and do not hesitate to mark this answer as solution if it helped.

Trimming off.yxmd