Separating a Text with some " - "

I am Uploading a Excel file, the TEXT is in a single cell that contain " - ". When  I open the data, I will like to display the TEXT into 3 different INPUT.


Example: TEXT:  SHOES - SOLES - LACES

Department: SHOES

Loss Type:SOLES

Loss Sub Type: Laces

Hi Miguel Lopez,

You can make use of String_Split function. You need to add a dependency named Text. In it has this function (String_Split). There you need to pass the string and the delimiter (for your case it '-'). It will return the separated string in a list format. Please see the attached pic for reference.


Hi Miguel Lopez,

As Pranav mentioned you can use String_Split for more details refer Text API.


Sravan

Hi Miguel Lopez!



I hope it will helps you!

Thanks and Best Regards,

Nuno Pereira