Want to truncate a field

I am a newbie. I am not a programmer. I can do this in Excel, but the boss wants to use Alteryx. So here I am. My data is pulled from a HUGE data set that is has been parsed by a programmer into applicable fields for our use. We are trying to set up a workflow to have the redundant tasks are automatic. Simple... (NOT!)... anyway I need to truncate one of the fields. An example in the column is (identifying information replaced with x's for the letters:

1/17/2024 10:00:00 AM Txx Sxx Pxxx Txxx12 xx

All I want is the date. How do I do this? Help please.

rene

Best Practices

Accepted answers

DataNath

Hey @rhearns1, if this field is consistently in this format then you could use something like this:

The inner FindString() function looks for the first instance of a space.

The outer, Left() function then takes the first N characters of the string, where N is the index found by the FindString() within.

Truncate field after date.yxmd

All comments

ShankerV

Hi @rhearns1

One way of doing this.

([0-9/]+\s[0-9:]+\s.{2})

([0-9/]+)\s

Many thanks

Shanker V

DataNath

Hey @rhearns1, if this field is consistently in this format then you could use something like this:

The inner FindString() function looks for the first instance of a space.

The outer, Left() function then takes the first N characters of the string, where N is the index found by the FindString() within.

Truncate field after date.yxmd

rhearns1

Shanker, Thank you. But the results included the time for which I do not want.

rhearns1

This worked wonderfully!!!!! THANK YOU!

TheUdbhav

Hi @rhearns1 ,

Hope you are well.

You can simply use DateTime Function. Configure it to Convert "String to Date/Time Format" and specify the format of the incoming string. This will give you Date part.
Solution attached for your reference. Please let me know if I have further questions.

Thanks

Use DateTime Field.yxmd

HomesickSurfer

Hi @rhearns1

If the date is the first word in your string, GetWord([Field1], 0) works.

rhearns1

I would like to thank all for the replies. I wasted 1 hour trying to figure this out!!!!! 👍

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15873

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703