Trimming off

[rmartinez4]

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.

Name	Output
FunctomloopNnJina-0::sunmazz-00288	FunctomloopNnJina-0::sunmazz-00288
venuscollector000	venuscollector000
uranucolumns524	uranucolumns524
uranucolumnsr5412	uranucolumnsr5412
uranucolumns118	uranucolumns118
SUN@00.43.00.7	00.43.00.7
JupitersMarsHolder@T123456789TY	T123456789TY
TT123PTTXSaunar@xxxTTT01	xxxTTT01
XXXSXFarr@XXXSPVERO00.feyppsmoldixgt.com	XXXSPVERO00
XXXSXTarr@XXXSPVERO01.feyppsmoldixgt.com	XXXSPVERO01
Mars@00.88.00.9	00.88.00.9
mitch	mitch

Thank you,

[JamesCharnley]

Hi @rmartinez4,

This looks like a good case for RegEx. Somebody better at RegEx than me will be able to pipe up with a one tool solution, but this should dynamically work in the meantime:

[Emmanuel_G]

@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.

[rmartinez4]

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,

[JamesCharnley]

@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.