Extract string left of @ character

You can do it following these steps:

-Create a variable named myResult (string type)

-Create a variable named myResults (collection type)

-Create a variable named myIndex (number type-default 0)

-Add the action named "Regular Expression"

-Add the action named "Collection operation"

You will get the result in "myResult"

Thanks Fernando

Hi Fernando Hunth​

Is there a way to do this for multiple splits.. example..

I want to extract text in a date field "3/04/2016 12:00 am." my desired result is 3042016

Please let me know if this is possible

Thanks,

Kimberley

You could use the fn-Replace function

fn-Replace (     fn-Replace ( {yourVar}, "12:00 am.", "" )   , "/" , "" )

Is there a reg ex that doesn't require the use of a collection operation to get text before a specific character?

HI there, 

any chance i can split by -

Filename: P101S-AS-6801-18010.01 to be used  and copy the details as metadata into columns. the first 5 characters are location, AS will be city code, 6801 will be door no and 18010 will be unique code. 

Thanks in advance.