SAP Lumira: How to split on Hyphen

[Former Member]

How to split the column on Hyphen?

Data looks like

TX-2016-75038

I can do at source database or file etc but want to do in SAP Lumira - prepare level.

[TammyPowlas · Accepted solution]

Depending on how your data is set up, I would replace the hyphen with a space as follows in the Prepare room:

Then I would split at space in the Prepare room as shown

Good luck

[Former Member · Accepted solution]

Yes you are right but that is two step process; why can't we split at one go like in excel we can use any symbol etc to split??

[TammyPowlas · Accepted solution]

Hi - I agree; in fact there is an idea for this on Idea Place at https://ideas.sap.com/D33786 - please vote for it.

[Former Member · Accepted solution]

Hi Bhalchndra,

The one step split on any character is available but with limitations. When you use the Split functionality and replace <Space> with - , it would only split at the first occurrence. So it works when you would need to separate two characters. But Tammy's recommendation works best for your scenario.

Thank you,

Varun Anand