Split string using regex

[hkanp]

Hi,

Is there a method to split below strings to 3 columns ?

50 38

28-32

401/28-32

401 28-32

Thanks,

[grazitti_sapna]

Hi @hkanp , the simplest way would  be to replace characters such as / and - with a space and then use text to column using space as delimiter and it will work. Please follow the screenshoat and workflow for understanding.

I hope it helps!

Thanks.

[DavidP]

You can also use multiple delimiters in a single Text to columns tool, so putting \s-/ in the delimiter field would split the split the field by all 3 (\s represents a space)

[jdunkerley79]

You can do this directly in the Text to Columns tool and list all 3 valid delimiters in the input like:

[hkanp]

Hi all

Thank you so much for all the quick responses.

One more thing,

How do i split the addresses as below into different columns ?

Thanks,

[grazitti_sapna]

@hkanp , try this solution I hope it works.

Thanks.

[hkanp]

Hi @ grazitti_sapna,

This is perfect, only one thing,

if there are any addresses like "RecordID= 1" (ex: 1 Pacific hwy")

I want to move number to "Street No 1" column instead "Unit No" column.

All the other addresses are split correctly.

Much appreciated your support

Thanks,

[grazitti_sapna · Accepted solution]

@hkanp , please find the solution below I have modified the workflow.

Thanks!

[hkanp]

Hello @grazitti_sapna

Much appreciated your help so far,

Im still struggling to split the below patterns to appropriate columns.

Could you please help me ?

Thanks

[hkanp]

I was able to fixed the issue.

Thank you so much your help

Much appreciated

Thanks !